3 ms·
> which even MySQL manages to get right. hahahaha. If you think MySQL gets this right, you haven't thought about it much. http://www.pgcon.org/2014/schedule/
by dbenhur 12y ago
> which even MySQL manages to get right.
hahahaha.
If you think MySQL gets this right, you haven't thought about it much.
http://www.pgcon.org/2014/schedule/events/661.en.html http://www.pgcon.org/2014/schedule/events/661.en.html
https://wiki.postgresql.org/wiki/UPSERT https://wiki.postgresql.org/wiki/UPSERT
- tveita 12y agoNone of those links say that MySQL's ON DUPLICATE KEY UPDATE doesn't work as intended. There's a single caveat: "If more than one unique index is matched, only the first is updated. It is not recommended to use this statement on tables with more than one unique index." That isn't a problem for most users since the use cases for upsert tends to be simple by nature, with a primary key that you want to set to the latest values whether or not it exists.