MySQL: ON DUPLICATE KEY UPDATE

Now that’s something I did not know: one can perform an insert, but if you specify ON DUPLICATE KEY UPDATE (available since MySQL 4.1.0) in your query, the row will get updated … now that basically combines two queries in one (a SELECT and then an INSERT or UPDATE depending on the number of rows returned from the SELECT)! REPLACE INTO apparently also does the trick (supports Primary Keys, not just Uniques). Thanks for the hat tip Ryan!

Published by Bramus!

Bramus is a Freelance Web Developer from Belgium. From the moment he discovered view-source at the age of 14 (way back in 1997), he fell in love with the web and has been tinkering with it ever since (more …)

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.