23
23
select * from t1 order by pk1;
24
24
UPDATE t1 set pk1 = 4 where pk1 = 1;
25
25
select * from t1 order by pk1;
27
27
UPDATE t1 set pk1 = 4 where pk1 = 2;
28
28
UPDATE IGNORE t1 set pk1 = 4 where pk1 = 2;
29
29
select * from t1 order by pk1;
30
31
UPDATE t1 set pk1 = 1, c = 2 where pk1 = 4;
31
32
UPDATE IGNORE t1 set pk1 = 1, c = 2 where pk1 = 4;
32
33
select * from t1 order by pk1;