- 博客(1)
- 收藏
- 关注
原创 mysql 随机获取100记录
1:select * from t_sms_number_section ORDER BY RAND() limit 100;-- 7.140ms :2:SELECT * FROM t_sms_number_section AS r1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM t_sms_number_section))
2013-09-29 10:15:17 533
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人