Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
September 25, 2005, 3:38 pm
rate this thread
Re: ON DUPLICATE KEY UPDATE with an old version of MySQL
Attempt an insert. If it fails due to a duplicate key error, do the
update. Oh, yes, to really mimic the behavior you need to put locks
around the two queries to prevent something else from deleting
the record in between the two.
Gordon L. Burditt
- » Reading Variables available in shell program into MySQL
- — Next thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum