MySQL has REPLACE INTO. SQLite has REPLACE INTO too. MySQL has INSERT INTO ... ON DUPLICATE KEY UPDATE. This is the functionality that SQLite now has. The d

MySQL has REPLACE INTO. SQLite has REPLACE INTO too. MySQL has INSERT INTO ... ON DUPLICATE KEY UPDATE. This is the functionality that SQLite now has. The difference between REPLACE and ON DUPLICATE KEY UPDATE is subtle but useful.