MySQL Forums
Forum List  »  Oracle

Re: Oracle rowid column = mysql ??
Posted by: Josh Chamas
Date: May 25, 2005 12:19AM

Marilyn Drewry wrote:
> 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

We do not have a rowid. For your purpose, the best thing would be to
define a surrogate primary key with an auto_increment field, and use
that to reference your row for subsequent updates.



Josh Chamas
Director, Professional Services
MySQL Inc.,
Get More with MySQL!

Options: ReplyQuote

Written By
May 11, 2005 12:17PM
Re: Oracle rowid column = mysql ??
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.