MySQL first few lines to the first few lines of statements

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

MySQL first few lines to the first few lines of statements