SQLite INSERT-重复键更新(UPSERT) [英] SQLite INSERT - ON DUPLICATE KEY UPDATE (UPSERT)

问题描述

MySQL具有以下内容:

MySQL has something like this:

INSERT INTO visits (ip, hits)
VALUES ('127.0.0.1', 1)
ON DUPLICATE KEY UPDATE hits = hits + 1;

据我所知，SQLite中不存在此功能，我想知道的是，是否有任何方法可以实现相同的效果而不必执行两个查询.另外，如果这不可能，那么您更喜欢什么:

As far as I know this feature doesn't exist in SQLite, what I want to know is if there is any way to achive the same effect without having to execute two queries. Also, if this is not possible, what do you prefer:

1. 选择+(插入或更新)或
2. 更新(如果更新失败，则+插入 )

推荐答案

从3.24.0开始，SQLite还支持upsert ，所以现在您只需编写以下内容

Since 3.24.0 SQLite also supports upsert, so now you can simply write the following

INSERT INTO visits (ip, hits)
VALUES ('127.0.0.1', 1)
ON CONFLICT(ip) DO UPDATE SET hits = hits + 1;

这篇关于SQLite INSERT-重复键更新(UPSERT)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！