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