MYSQL 随机查询百万级

最新推荐文章于 2024-01-23 14:18:50 发布

原创最新推荐文章于 2024-01-23 14:18:50 发布 · 677 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #join

mysql 专栏收录该内容

20 篇文章

订阅专栏

本文介绍了一种使用SQL进行随机产品数据查询的方法。通过RAND()函数结合子查询来实现从产品表中随机选取一条或多条记录的功能。这种方法适用于需要展示随机商品推荐等场景。

SELECT * FROM `product` WHERE `ID` >= (SELECT floor(RAND() * (SELECT MAX(id) FROM `product`))) ORDER BY `ID` LIMIT 7 SELECT * FROM `product` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(`ID`) FROM `product`)-(SELECT MIN(`ID`) FROM `product`))+(SELECT MIN(`ID`) FROM `product`)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id LIMIT 1 SELECT * FROM `product` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(`product_id`) FROM `product`)-(SELECT MIN(`product_id`) FROM `product`))+(SELECT MIN(`product_id`) FROM `product`)) AS id) AS t2 WHERE t1.`product_id` >= t2.id ORDER BY t1.`product_id` LIMIT 7