title: SQLite "INSERT OR REPLACE INTO" vs. "UPDATE ... WHERE"
body: <p>I've never seen the syntax <code>INSERT OR REPLACE INTO names (id, name) VALUES (1, "John")</code> used in SQL before, and I was wondering why it's better than <code>UPDATE names SET name = "John" WHERE id = 1</code>. Is there any good reason to use one over the other. Is this syntax specific to SQLite?</p>