On Apr 26, 5:27 pm, "Peter H. Coffin" <hell...@ninehells.com> wrote:
> On 25 Apr 2007 21:39:39 -0700, hi and hello wrote:
>
> > this is for the reporting
> > does someone knows?
>
> 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


You can also do this:

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