|
1
by brian
clean slate |
1 |
drop table if exists t1;
|
2 |
CREATE TABLE t1 (
|
|
3 |
gesuchnr int(11) DEFAULT '0' NOT NULL,
|
|
4 |
benutzer_id int(11) DEFAULT '0' NOT NULL,
|
|
5 |
PRIMARY KEY (gesuchnr,benutzer_id)
|
|
6 |
);
|
|
7 |
replace into t1 (gesuchnr,benutzer_id) values (2,1);
|
|
8 |
replace into t1 (gesuchnr,benutzer_id) values (1,1);
|
|
9 |
replace into t1 (gesuchnr,benutzer_id) values (1,1);
|
|
10 |
alter table t1 engine=heap;
|
|
11 |
replace into t1 (gesuchnr,benutzer_id) values (1,1);
|
|
12 |
drop table t1;
|
|
13 |
create table t1 (a tinyint not null auto_increment primary key, b char(20) default "default_value");
|
|
14 |
insert into t1 values (126,"first"),(63, "middle"),(1,"last");
|
|
15 |
insert into t1 values (1,"error");
|
|
16 |
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
|
|
17 |
replace into t1 values (126,"first updated");
|
|
18 |
replace into t1 values (63,default);
|
|
19 |
select * from t1;
|
|
20 |
a b
|
|
21 |
126 first updated
|
|
22 |
63 default_value
|
|
23 |
1 last
|
|
24 |
drop table t1;
|