2013年12月2日
MYSQL 随机选取几条数据
摘要： SELECT * FROMtablename AS r1 JOIN (SELECT ROUND(RAND() *(SELECT MAX(id)FROM tablename)) AS id) AS r2 WHERE r1.id >= r2.id ORDER BY r1.id ASC LIMIT 10000;SELECT * FROM tablename ORDER BY rand() LIMIT 5第一种速度比第二种快的多 阅读全文
posted @ 2013-12-02 15:12 杨桃 阅读(442) 评论(0) 推荐(0) 编辑