How to get the row number at mysql

When I use select and get a result set ,then I found a column that
indicate the row number in the result set is needed.This is for
reporting.
Is there a function which can fetch the row number in the result set ?
thanks.

hi and hello wrote:
> When I use select and get a result set ,then I found a column that
> indicate the row number in the result set is needed.This is for
> reporting.
> Is there a function which can fetch the row number in the result set ?
> thanks.
>

There is no "row number" in MySQL (and in SQL in general, although some
RDBMSs have implemented one). But you can put in an autoincrement
column to give you a similar effect.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

On Apr 26, 5:53 am, hi and hello <nkappro...@gmail.com> wrote:
> When I use select and get a result set ,then I found a column that
> indicate the row number in the result set is needed.This is for
> reporting.
> Is there a function which can fetch the row number in the result set ?
> thanks.

There are no row numbers as such. Try to describe your problem a
little more thoroughly and we'll see if we can help.