SQLite 插入 - 重复键更新 (UPSERT)

SQLite INSERT - ON DUPLICATE KEY UPDATE (UPSERT)(SQLite 插入 - 重复键更新 (UPSERT))

问题描述

MySQL has something like this:

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

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. SELECT + (INSERT or UPDATE) or
2. UPDATE (+ INSERT if UPDATE fails)

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 插入 - 重复键更新 (UPSERT)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！