The statements described below are used to query the first few records of mysql. This method is for your reference. If you are interested in mysql query, take a look.
SELECT * FROM table LIMIT 5;
Select * from issu_info limit 0, 6
Limit 0, 6
This is correct. The first six items are displayed.
Select * from issu_info limit 7, 6;
Limit 7, 6
Take from 8th, take 6
Select * from table order by rand () limit 1
This is a random mysql query that selects a record. If you want to extract multiple records, change 1 to the maximum number you want.
Using a feature of the select statement in mysql, you can easily implement paging of query results. The syntax of the select statement is as follows:
SELECT [STRAIGHT_JOIN] [SQL _SMALL_RESULT] [SQL _BIG_RESULT] [HIGH_PRIORITY]
[DISTINCT | DISTINCTROW | ALL]
Select_expression ,...
[Into outfile 'file _ name' export_options]
[FROM table_references
[WHERE where_definition]
[Group by col_name,...]
[HAVING where_definition]
[Order by {unsigned_integer | col_name | formula} [ASC | DESC],...]
[LIMIT [offset,] rows]
[PROCEDURE procedure_name]
The above is the implementation method of the first few records of mysql query.
About MySQL query Cache Mechanism
Use MySQL Union to avoid sequential Storage
Five common MySQL Log types
Mysql Log File description
Tips for compressing MySQL Data Files