百万数据随机取行

SELECT * FROM table
WHERE id >= (SELECT FLOOR(RAND() * (SELECT MAX(id) FROM table)))
ORDER BY id LIMIT 1

ID 最小值不为 1 开始时

SELECT * FROM table

WHERE id >= (SELECT floor(RAND() * ((SELECT MAX(id) FROM table) - (SELECT MIN(id) FROM table)) + (SELECT MIN(id) FROM table)))

ORDER BY id LIMIT 1;

查询数量大于1时

SELECT * FROM table

WHERE ID >= (select floor(RAND() * (SELECT MAX(id) - 200 FROM table)))

ORDER BY id LIMIT 200;