A very frequently asked question here is how to do an upsert, which is what MySQL calls INSERT ... ON DUPLICATE UPDATE and the standard supports as part of...
I want to add a row to a database table, but if a row exists with the same unique key I want to update the row. For example: INSERT...