论坛 › MySQL运维 › MySQL随机取一条数据 取指定条数的数据

纸水仙 发表于 2016-10-22 05:02:10

MySQL随机取一条数据 取指定条数的数据

　　第一个：最简便 性能最差的：
　　

SELECT * FROM tb_goods ORDER BY RAND() limit 3;


　　第二个：性能比较好但是只能出来一条的：
　　

SELECT *
FROM `goods` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(goods_id) FROM `goods`)-(SELECT MIN(goods_id) FROM `goods`))+(SELECT MIN(goods_id) FROM `goods`)) AS id) AS t2
WHERE t1.goods_id >= t2.id
ORDER BY t1.goods_id LIMIT 1;

http://database.iyunv.com/art/201010/229981.htm

查看完整版本: MySQL随机取一条数据 取指定条数的数据