笔记 - MySQL随机取一条数据

2017-11-7 墨渊 杂七杂八

笔记

MySQL随机取一条数据的代码,重复率高,但是代码简单

("select * from redurl_jump where id >= (select floor(rand() * (select max(id) from redurl_jump)))  order by id limit 1;"); 

标签: 笔记 学习

继续阅读