MySQL Forums
Forum List  »  InnoDB

Re: Update a row or insert if don´t exist
Posted by: Andrew Gilfrin
Date: June 16, 2005 06:52AM

Yep your right of course, I did find it in the docs after I posted.

However you said

"The update is actually completely independent from the insert, so in theory you could even do something in another table."

Thats doesn't seem to be the case. It trys the insert and if if fails it does the update using the key from the insert.

Andrew Gilfrin
My MySQL related Blog
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information

Options: ReplyQuote

Written By
Re: Update a row or insert if don´t exist
June 16, 2005 06:52AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.