1 2 3 4 5 6 7 8 9 10 11 12 13 |
drop table if exists t1; create table t1 (a int not null auto_increment primary key, b char(20) default "default_value"); insert into t1 values (126,"first"),(63, "middle"),(1,"last"); insert into t1 values (1,"error"); ERROR 23000: Duplicate entry '1' for key 'PRIMARY' replace into t1 values (126,"first updated"); replace into t1 values (63,default); select * from t1 order by a; a b 1 last 63 default_value 126 first updated drop table t1; |