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?

Example:

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

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Oracle rowid column = mysql ??
50178
May 11, 2005 12:17PM
23954
May 25, 2005 12:19AM
17235
August 12, 2005 06:22PM
15457
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.