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.
| Posted by dustin on March 6, 2006 with category tags of MySQL sql |
| ||||
Written by dustin
| randomdude.com Who is Dustin "Quasar" Sacks? |
|
|
| It happens sometimes. People just explode. Natural causes.[quote database] |
| F*ckin' tremendous issues here. I'm very satisfied to look your article. Thanks a lot and i'm having a look ahead to co... GUESSWHAT,GUESSWHAT, "IM SEXY AND I KNOW IT" ᣦ... Hi there, You've done a great job. I will certainly digg it and personally suggest to my friends. I am sure they will b... Very nice post and straight to the point. americans are jealous from canadian health care It's always nice when you can not only be informed, but also entertained! I'm sure you had fun writing this article.Exc... What matters is that Gears of war three kicks off pretty soon Howdy this is kind of of off topic but I was wanting to know if blogs use WYSIWYG editors or if you have to manually co... Very nice post and straight to the point. I am not sure if this is actually the best place to ask but do you folks have... thanks, i owe you :). Very clear explanation, keep up the good work mate. Thank you for another informative website. Where else could I get that type of info written in such an ideal way? I've ... There are certainly lots of details like that to take into consideration. That could be a nice level to carry up. I off... My father, Tom Huff, played the wizard in season 5, ep. 12 "Dragonslayer" All the reptiles were ours as well. I have ... Oh my.. Actually the code of the BACKSTER and LAIT might be the other way around with respect to the family killing? and what i... pogi ako Emily takes a trip, driving with a constant velocity of 81.5 km/h to the north except for a 22 min rest stop. If Emily'... can any1 send me when is the ea interview is going to held? Lot of misinformation about high taxes in Canada..the taxes are not at all as high as its claimed to be. They are sligh... hi frnds....can anyone send me written test patern nd placment papers of EA sports...plz send me..its urgnt..i hav intr... |
Hey You! Subscribe to
dustin's RSS feed.
Or get wider opinion in the Vorg All Author feed.
Members login here.
© Vorg Group.