取出多条(最大值-最小值)* 随机数 +最小值
SELECT * FROM users WHERE userId >= ((SELECT MAX(userId) FROM users)-(SELECT MIN(userId) FROM users)) * RAND() + (SELECT MIN(userId) FROM users) LIMIT 1
做项目中遇到所有的常用知识点(javascript、php、mysql、apache、nginx)更新
标签:
取出多条(最大值-最小值)* 随机数 +最小值
SELECT * FROM users WHERE userId >= ((SELECT MAX(userId) FROM users)-(SELECT MIN(userId) FROM users)) * RAND() + (SELECT MIN(userId) FROM users) LIMIT 1
做项目中遇到所有的常用知识点(javascript、php、mysql、apache、nginx)更新
标签: