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 achieve 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)