mysql中随机取出一张表中N条记录

mysql:

select * from  table表名 ORDER BY RAND() LIMIT  N;

 

 例：SELECT * FROM t_product ORDER BY RAND() LIMIT 5;