INSERT INTO `books ` (`name`,`count`,`num`) VALUES ('windows','1','2'),('','linux','1','3') ON DUPLICATE KEY UPDATE `count` = `count` + VALUES(`COUNT`), `num`=`num`+VALUES(`num`);
相关文章
- Mybatis-Plus中update更新操作用法
- Java8 Duplicate key 异常解决
- update 语句where 条件in是个select 子句的返回结果集的用法
- ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails
- python中max、min函数key的用法
- vue2 中this.$emit(“update:xx“,value)和的用法
- Duplicate entry '' for key 2
- 解决办法之Duplicate entry ‘1‘ for key ‘PRIMARY‘
- Gorm Save更新踩坑记录|Gorm Save主键冲突|Duplicate entry ‘xxxx‘ for key ‘PRIMARY
- mysql插入操作跳过(ignore)、覆盖(replace into)、更新(on duplicate key)