Mysql queries the rows from the row to query the records of the last row and the row to query the first and last rows.
Mysql queries the rows from the row to query the records of the last row and the row to query the first and last rows.
1. query the first row of records:
Select * from table limit 1
2. query records from row n to row m
Select * from table1 limit n-1, m-n;
SELECT * FROM table LIMIT 5, 10; returns records FROM 6th rows to 15th rows
Select * from employee limit 3, 1; // return 4th rows
3. query the first n rows of records
Select * from table1 limit 0, n;
Or
Select * from table1 limit n;
4. n rows of records after Query
Select * from table1 order by id desc dlimit n; // sort in reverse order. the id of the First n rows is in auto-incrementing form.
5. query the next record of a record ($ id)
Select * from table1 where id> $ id order by id asc dlimit 1
6. query the previous record of a record ($ id)
Select * from table1 where id <$ id order by id desc dlimit 1
