mysql获取随机数据的方法_MySQL:bitsCN.com 1.order by rand()数据多了极慢，随机性非常好，适合非常小数据量的情况。SELECT * FROM table_name AS r1 JOIN (SELECT (ROUND(RAND() * (SELECT ABS(MAX(id)-MIN(id)-$limit) FROM table_name))