SQLite - ON DUPLICATE KEY UPDATE
- by Alix Axel
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'm know this feature doesn't exist in SQLite, what I want to know is if there is any way to archive the same effect without having to execute two queries. Also, if this is not possible, what do you prefer:
SELECT + (INSERT or UPDATE) or
UPDATE (+ INSERT if UPDATE fails)
