MySQL queries the rows from rows to rows

1. query the records of the first row: select * fromtablelimit12. query the records from row n to Row m. select * fromtable1limitn-

1. query records in the first row: select * from table limit 1 2. query records from row n to row m in select * from table1 limit n-

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