MySQL Query the first few lines to the first few lines of the statement _mysql

1, query the first line of records:
SELECT * FROM table Limit 1
2, inquires the nth row to the M line record
SELECT * FROM table1 limit n-1,m-n;
SELECT * FROM table LIMIT 5, 10; Returns records from line 6th to line 15th
SELECT * FROM Employee limit 3, 1; Back To Line 4th
3, the query before the N line records
SELECT * FROM table1 limit 0,n;
Or
SELECT * FROM table1 limit n;
4, the query after the N line records
SELECT * FROM table1 ORDER BY id desc dlimit n;//reverse order, take the first n row ID as the self-added form
5, query a record ($id) of the next record
SELECT * FROM table1 where id> $id ORDER by ID ASC Dlimit 1
6, query a record ($id) of the previous record
SELECT * FROM table1 where id< $id order BY id desc dlimit 1