MySQL Forums
Forum List  »  Oracle

Re: Convert oracle SQL statement to MySQL
Posted by: super sobbie
Date: November 15, 2012 08:45AM

My problem is that it is a select statement on tne same table inside of an update statement. According to the documentation from mySQL this is not possible. So I am looking for another way to accomplish this in mySQL. do I have to create a sepereate table and do something funky that way or is there a case/if statement that may be built to do this.

Any help would be great.

Thanks in advance to anyone.


Options: ReplyQuote

Written By
November 06, 2012 02:54PM
Re: Convert oracle SQL statement to MySQL
November 15, 2012 08:45AM

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.