效率比较高的,推荐,但是随机的有序的=-=
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
效率比较高的,推荐,但是随机的有序的=-=
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