3 ms·
MySQL named this action as "REPLACE" instead of UPSERT which isn't an english word.
by z92 8y ago
MySQL named this action as "REPLACE" instead of UPSERT which isn't an english word.
- willvarfar 8y agoMySQL 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.