displaying the row no.??

[Johan]

hi guys,
i am working on mysql platform for a new project. how can i display or see the row no. or the row id. as we have in oracle like
"select rownum,ename,dept from employee" or
"select rowid,ename,dept from employee" in mysq.l i am using mysql ver 5.0 with mysql query browser ver 1.1.2. i have table in which there will frequent addtion of row of values and it has unique primary key but the values are not in the incremental order so when i query the table using the select command the rows are displayed in the order of values not the order in which they were inserted as:

name dateofinsertion

ABC 2006-07-15
CDS 2006-07-12
BZS 2006-07-12
XYZ 2006-07-14

so i not able to know which was inserted first if i order by date then if there are more than one values the same qusetion arises.
thanks in advance! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Saggie]

MySQL does not maintain row numbers or track when rows were entered, or maintain any specific row ordering.

You can generate a sequence of numbers at any time like so:

SET @num = 0;

SELECT (@num := @num+1) AS rownum, ename, dept FROM employee;
but this will not necessary have any relationship with how the rows were originally inserted.

Or use timestamps to more accurately log when rows were inserted. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --