List:General Discussion« Previous MessageNext Message »
From:<horizonx Date:November 2 2002 12:43pm
Subject:RE: Select by row number
View as plain text  
> There is no row number in MySQL. You should use ORDER BY to
> retrieve data in particular order.

What about the following info in the manual p. 55?

Add a PRIMARY KEY or UNIQUE key to the table and use this. New in Version
3.23.11: If the PRIMARY or UNIQUE key consists of only one column and this
of type integer, one can also refer to it as _rowid.

Select by row numberhorizonx1 Nov
  • re: Select by row numberEgor Egorov2 Nov
    • RE: Select by row numberhorizonx2 Nov
      • re: RE: Select by row numberEgor Egorov4 Nov
Re: Select by row numberJan Steinman1 Nov
RE: Select by row numberhorizonx2 Nov
Re: Select by row numberMichael T. Babcock5 Nov