MySQL随机获取几条数据的方法

第一条效率更高 1. SELECT * FROM address WHERE id >= (SELECT floor(RAND() * (SELECT MAX(id) FROM address))) ORDER BY id LIMIT 0,10 2. SELECT *,RAND() as r FROM address ORDER BY r LIMIT 0,10

• 一条
• 效率
• 更高