geeta varu wrote:
does mySQL have
"rowid" or "rownum"
if yes please give an exampl
Please search the archives for "_rowid" to find the previous discussions
on this. It comes down to having an unsigned int auto_increment primary
key value in your table to use as the rowid. That's what "w
On Tuesday 18 February 2003 09:14, geeta varu wrote:
> does mySQL have
> "rowid" or "rownum"
> if yes please give an exampl
Well ..
_rowid exists in MySQL. If you have primary or unique key you can refer to
this column as _rowid. But this primary or unique key must consists of one
integer column
I have no problem doing this with server variables ... here is an example that
I tried on the acc (account) table in our db ...
SET @a:=0;
SELECT @a:=@a+1 AS MyRowNum, acc.* FROM acc;
This gives me the result that you are looking for ...
Eric
Peter Holm wrote:
> Hi,
> how do I get something
Hi Peter,
I'm not sure but I don't think it's possible with MySQL. The best you could
do is make sure you have a primary key on the table that is autoincrement.
This will give you a unique number for each row.
RowNum is very subjective since it is describing the row number in the
cursor you are
