Showing entries 1 to 1
Displaying posts with tag: ON DUPLICATE KEY UPDATE (reset)
May
01
2012
How to simulate MySQL’s INSERT statement extensions
Posted by Lukas Eder on Tue 01 May 2012 09:03 UTC
Tags:

I have previously posted about the SQL MERGE statement, and how powerful it is here: https://blog.jooq.org/arcane-magic-with-the-sql2003-merge-statement/ Unfortunately, not all databases support this statement. Also, very often it is quite a bit of overkill, when what you want to do is to simply INSERT or UPDATE a single record, depending on whether it already exists. MySQL's … Continue reading How to simulate MySQL’s INSERT statement extensions →

Showing entries 1 to 1