Re: Update a row or insert if don´t exist
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
------------------
http://gilfster.blogspot.com
My MySQL related Blog
http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information
Subject
Views
Written By
Posted
12827
May 20, 2005 04:45PM
4494
June 09, 2005 12:24AM
4863
June 13, 2005 11:06PM
3313
June 14, 2005 03:32AM
3575
June 14, 2005 06:37AM
Re: Update a row or insert if don´t exist
4229
June 16, 2005 06:52AM
3809
June 16, 2005 07:44PM
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.