INSERT ... ON DUPLICATE KEY UPDATE The other day I found out about MySQL's INSERT ... ON DUPLICATE KEY UPDATE statement. It allows you do do an INSERT when a given key doesn't exist, or to do an UPDATE statement when it does.
I have a lot of code that does a query to see if the given ID exists, and then does an INSERT or UPDATE depending on the condition. This statement should simplify such code nicely. Good thing I know about it now.
I'm not sure if this is MySQL specific or general SQL. I'm pretty firmly locked into MySQL already though, so it doesn't really matter to me.
| NEEd INSERT ON DUPLICATE KEY UPDATE|
Commenting is currently off. You can email the author.
Vorg — Tag Cloud — Archives
Written by dustinPhoto ShowcaseQuote Showcase
Friends of VorgComputer GamesPopular Posts