Mysql 高效随机生成N条记录

 1 select *, rand() as random FROM yef_exercises where id not in(1) order by random limit 1 // Mysql  

 

posted @ 2014-05-17 01:19  笨马儿  阅读(432)  评论(0编辑  收藏  举报