I think you need to add some kind of uniqueness to your table. Either a
date column (dates are only accurate to the nearest second which may not
be fine enough precision for your situation) or an auto_incremented
integer-type column (make sure you select the correct storage size for
your data).
To select row 10 to 30 below query might be useful
select * from mytable limit 10,20;
The query will list 11th record to 30th record.
N. Kavithashree wrote:
hello,
ususally we use :
select * from table limit 50;
This will display the rows which were entered first the table created
(i..e, that end
hello,
ususally we use :
select * from table limit 50;
This will display the rows which were entered first the table created
(i..e, that end);
if i wnat to select from the other side then what should i use ?
if there is a serial no column like id or some autoincremt column or DATE
then we ca
