Re: autonumber rows in SQL result, how to

"Miroslav I." <[EMAIL PROTECTED]> wrote: > - how to autonumber rows in SQL result > > I would like to put an auto numbering column in any SQL SELECT result, is it > possibile? You can use variables, for example: mysql> SELECT @id:=0; ++ | @id:=0 | ++ | 0 | ++ 1 row i

autonumber rows in SQL result, how to

- how to autonumber rows in SQL result I would like to put an auto numbering column in any SQL SELECT result, is it possibile? miroslav i.