Skip navigation links

MySQL Forums :: Oracle :: Oracle rowid column = mysql ??


Advanced Search

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 ?? 47891 Marilyn Drewry 05/11/2005 12:17PM
Re: Oracle rowid column = mysql ?? 22901 Josh Chamas 05/25/2005 12:19AM
Re: Oracle rowid column = mysql ?? 16648 William Ulrich 08/12/2005 06:22PM
Re: Oracle rowid column = mysql ?? 14847 philippe granger 09/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.