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
12836
May 20, 2005 04:45PM
4497
June 09, 2005 12:24AM
4867
June 13, 2005 11:06PM
3314
June 14, 2005 03:32AM
3577
June 14, 2005 06:37AM
Re: Update a row or insert if don´t exist
4230
June 16, 2005 06:52AM
3812
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.