搜索

+

95

-

mysql如何编写获取随机几条数据的sql？

mysql sql

mysql如何编写获取随机几条数据的sql？

网友回复

+

15

-

共有六种方法，第三种查询效率最高：

1：SELECT * FROM tablename ORDER BY RAND() LIMIT 想要获取的数据条数；

2：SELECT *FROM `table` WHERE id >= (SELECT FLOOR( MAX(id) * RAND()) FROM `table` ) ORDER BY id LIMIT 想要获取的数据条数;

3：SELECT * FROM `table` AS t1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM `table`)) AS id) AS t2 WHERE t1.id >= t2.id

...

点击查看剩余70%

我知道答案，我要回答

我有问题

私活外包

最新提问