效率比较高的,推荐,但是随机的有序的=-=
SELECT * FROM address WHERE id >= (SELECT floor(RAND() * (SELECT MAX(id) FROM address))) ORDER BY id LIMIT 0,10
参考:
https://blog.csdn.net/qdujunjie/article/details/18711167
mysql随机获取数据
世界上所有的不公平都是由于当事人能力不足造成的.
效率比较高的,推荐,但是随机的有序的=-=
SELECT * FROM address WHERE id >= (SELECT floor(RAND() * (SELECT MAX(id) FROM address))) ORDER BY id LIMIT 0,10
参考:
https://blog.csdn.net/qdujunjie/article/details/18711167