~drizzle-trunk/drizzle/development

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;