create table aaa(
id int auto_increment,
value int,
primary key(id),
unique key uk(value));
insert into aaa values(1,1);
insert into aaa values(null,1) ON DUPLICATE KEY UPDATE `id`=VALUES(`id`), value=VALUES(`value
ON DUPLICATE KEY UPDATE 的坑
最新推荐文章于 2024-03-12 10:33:15 发布