Re: Indexing Column for a result set of a SELECT

2002-09-12 Thread Paul DuBois
At 12:59 +0300 9/12/02, Fam. Tarniceru wrote: >Dear Sirs, > >How can I handle with this situation? >I need a special column in a SELECT statement - with LIMIT clause -, that >can index my rows from 1 upward in the result set, and I don't know how to >make it in MySQL. It is known that Oracle have

R: Indexing Column for a result set of a SELECT

2002-09-12 Thread Danilo Maurizio
lumn for a result set of a SELECT Dear Sirs, How can I handle with this situation? I need a special column in a SELECT statement - with LIMIT clause -, that can index my rows from 1 upward in the result set, and I don't know how to make it in MySQL. It is known that Oracle have a special f

Re: Indexing Column for a result set of a SELECT

2002-09-12 Thread Toni Strandell
You can use the auto increment column. However, you have to add it to the table. http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#example-AUTO_INCREMENT On Thu, 12 Sep 2002, Fam. Tarniceru wrote: > Dear Sirs, > > How can I handle with this situation? > I need a speci

Indexing Column for a result set of a SELECT

2002-09-12 Thread Fam. Tarniceru
Dear Sirs, How can I handle with this situation? I need a special column in a SELECT statement - with LIMIT clause -, that can index my rows from 1 upward in the result set, and I don't know how to make it in MySQL. It is known that Oracle have a special function (RowNum) for this problem. Best