1 drop table if exists t1,t2;
3 gesuchnr int(11) DEFAULT '0' NOT NULL,
4 benutzer_id int(11) DEFAULT '0' NOT NULL,
5 PRIMARY KEY (gesuchnr,benutzer_id)
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 insert into t1 (gesuchnr, benutzer_id) value (3,2);
11 replace into t1 (gesuchnr,benutzer_id) values (1,1);
12 replace into t1 (gesuchnr,benutzer_id) values (1,1);
13 insert into t1 (gesuchnr,benutzer_id) values (1,1);
14 ERROR 23000: Duplicate entry '1-1' for key 'PRIMARY'
15 replace into t1 (gesuchnr,benutzer_id) values (1,1);
16 select * from t1 order by gesuchnr;
22 CREATE TABLE t1(i INT PRIMARY KEY AUTO_INCREMENT,
27 INSERT INTO t1 VALUES (1,1,23),(2,2,24);
28 REPLACE INTO t1 (j,k) VALUES (1,42);
29 REPLACE INTO t1 (i,j) VALUES (17,2);
30 SELECT * from t1 ORDER BY i;
35 CREATE TABLE t2 (a INT(11) NOT NULL,
41 id INT(10) unsigned NOT NULL AUTO_INCREMENT,
42 i INT(11) DEFAULT NULL,
46 REPLACE INTO t2 (a,b,c,x,y,z,i) VALUES (1,1,1,'a','a','a',1),(1,1,1,'b','b','b',2), (1,1,1,'c','c','c',3);
47 SELECT * FROM t2 ORDER BY id;
50 REPLACE INTO t2(a,b,c,x,y,z,i) values (1,1,1,'a','a','a',1);
51 REPLACE INTO t2(a,b,c,x,y,z,i) values (1,1,1,'b','b','b',2);
52 SELECT * FROM t2 ORDER BY id;
56 drop table if exists t1;
57 create table t1 (pk int primary key, apk int unique, data int) engine=ndbcluster;
58 insert into t1 values (1, 1, 1), (2, 2, 2), (3, 3, 3);
59 replace into t1 (pk, apk) values (4, 1), (5, 2);
60 select * from t1 order by pk;
66 insert into t1 values (1, 1, 1), (2, 2, 2), (3, 3, 3);
67 replace into t1 (pk, apk) values (1, 4), (2, 5);
68 select * from t1 order by pk;
74 insert into t1 values (1, 1, 1), (4, 4, 4), (6, 6, 6);
75 load data infile '../../../std_data/loaddata5.dat' replace into table t1 fields terminated by '' enclosed by '' ignore 1 lines (pk, apk);
76 select * from t1 order by pk;
82 insert into t1 values (1, 1, 1), (3, 3, 3), (5, 5, 5);
83 load data infile '../../../std_data/loaddata5.dat' replace into table t1 fields terminated by '' enclosed by '' ignore 1 lines (pk, apk);
84 select * from t1 order by pk;
90 insert into t1 values (1, 1, 1), (2, 2, 2), (3, 3, 3);
91 replace into t1 (pk, apk) select 4, 1;
92 replace into t1 (pk, apk) select 2, 4;
93 select * from t1 order by pk;