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
==================