I want to add the row number as a column of the result set - MySQL

[hi]

this is for the reporting
does someone knows?

[Peter]

On 25 Apr 2007 21:39:39 -0700, hi and hello wrote: 

Add an autoincrementing integer column. Use that. They make dandy
primary keys as well.

--
53. If the beautiful princess that I capture says "I'll never marry you!
Never, do you hear me, NEVER!!!", I will say "Oh well" and kill her.
--Peter Anspach's list of things to do as an Evil Overlord

[strawberry]

On Apr 26, 5:27 pm, "Peter H. Coffin" <com> wrote: 
>
> Add an autoincrementing integer column. Use that. They make dandy
> primary keys as well.
>
> --
> 53. If the beautiful princess that I capture says "I'll never marry you!
> Never, do you hear me, NEVER!!!", I will say "Oh well" and kill her.
> --Peter Anspach's list of things to do as an Evil Overlord[/ref]


You can also do this:

mysql> set N = 0;
mysql> SELECT N := N +1 AS number, * FROM my_table;

[strawberry]

On Apr 28, 2:44 pm, strawberry <com> wrote: 
> [/ref]
> 
> 
>
> You can also do this:
>
> mysql> set N = 0;
> mysql> SELECT N := N +1 AS number, * FROM my_table;[/ref]


Actually, if using ' * ', then it has to come before the counter.
Also, you have to remember to reset N afterwards!

[ashore]

What you're asking for is "an un-natural act" in SQL. The point is
taht an SQL