- values值的插入
insert into student(id,name) values(3,'kobe'),(4,'Curry') ON DUPLICATE KEY UPDATE name=values(name)
- select查询结果批量插入
insert into student select id,name from newStudent ON DUPLICATE KEY UPDATE name=VALUES(name)
insert into student(id,name) values(3,'kobe'),(4,'Curry') ON DUPLICATE KEY UPDATE name=values(name)
insert into student select id,name from newStudent ON DUPLICATE KEY UPDATE name=VALUES(name)
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
