mysql查询前几条记录的实现方法

，不妨一看。SELECT * FROM table LIMIT 5;select * from issu_info limit 0,6Limit 0,6这里是对的，显示前6条select * from issu_info limit 7,6;Limit 7,6从第8条开始取,取6条select * from table order by rand() limit 1这是随机mysql查询时选取一个记录,如果想提取多个就将1改为你想要的数目Top在mysql中利用select语句的一个特性就可以很方便地实现查询结果的分页，select语句的语法：SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [HIGH_PRIORITY][DISTINCT | DISTINCTROW | ALL][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]本回答被提问者和网友采纳