MySQL Forums
Forum List  »  Oracle

Oracle rowid column = mysql ??
Posted by: Marilyn Drewry
Date: May 11, 2005 12:17PM

Perhaps this belongs to the SQL thread but I want to do something similiar to what I have done in Oracle.

I have a row that I want to duplicate by selecting it and then inserting into the same table.
In Oracle I can then select info along with rowid, then using the rowid update only the new record.

Does mysql support anything like that?


insert into tablex select * From tablex where somfield = 'a';
select rowid, somfield from tablex where somfield = 'a"; < returns 2 rows
update tablex set somfield = 'b' where rowid = 'XXXXXX'; < updates only the new record


Options: ReplyQuote

Written By
Oracle rowid column = mysql ??
May 11, 2005 12:17PM
May 25, 2005 12:19AM
August 12, 2005 06:22PM
September 14, 2007 08:22AM

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.