summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/insert_update_autoinc-7150.result
blob: 967734793100c43912f21a9f90710ce174e2bd7f (plain)
1
2
3
4
5
6
7
8
9
create table t1 (a int(10) auto_increment primary key, b int(11));
insert t1 values (null,1);
insert t1 values (null,2), (1,-1), (null,3) on duplicate key update b=values(b);
select * from t1;
a	b
1	-1
2	2
3	3
drop table t1;