我想在mysql表中插入新行,但是当同一行已经存在时,则更新行。所以,例如
`INSERT INTO table (character_id, data) VALUES(1212, "test")` WHEN character_id exist then UPDATE...有人知道如何为此创建sql查询吗?
发布于 2019-09-19 09:09:53
您可以使用以下查询来执行此操作:
IF EXISTS (select * from demo where character_id=1212)
update demo
set character_id=123 and data='test'
where id=1212
ELSE
insert into demo (character_id, data)
values(1212, "test");更有效的方法将如juergen d在评论中所建议的那样:
INSERT INTO demo (character_id, data)
VALUES(1212, "test")
ON DUPLICATE KEY UPDATE character_id=123 ,data='test'参考: MySQL文档-重复插入
https://stackoverflow.com/questions/58007453
复制相似问题