sampra

 Profile Answers by sampra 

• Mar 10th, 2008

 

as row id is in oracle same as id is in mysql but in mysql there is no concept of rownum

landonmkelsey

 Profile Answers by landonmkelsey 

• Nov 15th, 2008

 

Here is the MySQL row id

Create table log_bookid (logbookID int IDENTITY (1,1),fdate datetime, actype varchar(16), acid varchar(16), nlandings int, nhours float);

I am trying to go backwards i.e. find the Oracle version

gakorde

 Profile Answers by gakorde 

• Oct 5th, 2010

 

There is no concept like rowid in MySQL

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed 

• Jun 29th, 2011

 

Hi,


There is no rowid counterpart in MySQL. But if you want same feature in MySQL then you need to add following column in each table you need rowid.

id bigint unsigned not null autoincrement

If you need any further assistance or discussion please mail me at altafhsayyed@yahoo.com

Thanks and regards