MySQL 不存在则插入 存在则修改

1.insert ignore into

重复忽略

insert ignore into user values(1,"张三",2)

2.on duplicate key update

唯一约束重复更新

insert into user values(1,"张三",2) on duplicate key update age = 3

3.replace into

替换

replace into user values(2,"张三",2)

4.insert if not exists

不存在则插入

insert into user(id,name,age) select 4,"张三",2 from user where not EXISTS ( select id from user where id = 4) limit 1