mysql 批量数据存在即更新 不存在新增
insert into `user` ( id, name, gender, birthday, address )
values( 1, '张三', 1, '2021-02-14', '黑龙江' )
on duplicate key update
name =values(name),
gender =values(gender),
birthday =values(birthday),
address =values(address)
mysql 批量数据存在即更新 不存在新增
insert into `user` ( id, name, gender, birthday, address )
values( 1, '张三', 1, '2021-02-14', '黑龙江' )
on duplicate key update
name =values(name),
gender =values(gender),
birthday =values(birthday),
address =values(address)