MySQL Forums
Forum List  »  Oracle

Re: Oracle rowid column = mysql ??
Posted by: philippe granger
Date: September 14, 2007 08:22AM

Its possible to have the row id by using var like that

set @a := 0;
select *, @a := @a+1 as rowid
from table
limit 10 ;

Options: ReplyQuote


Subject
Views
Written By
Posted
51906
May 11, 2005 12:17PM
24975
May 25, 2005 12:19AM
17962
August 12, 2005 06:22PM
Re: Oracle rowid column = mysql ??
16236
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.