MySql从表结果集中随机取一条数据

页面导航:首页 > 数据库 > Mysql > MySql从表结果集中随机取一条数据

MySql从表结果集中随机取一条数据

来源: 作者: 时间:2016-02-17 10:07 【

MySql从表结果集中随机取一条数据[sql] Select * from (Select (@rowNo :[email protected]+1) AS rowno, pwd from pur_admininfo, (Select @rowNo := 0) b) tmp where rowno=(Select Round(Rand() *...
MySql从表结果集中随机取一条数据
 
[sql] 
Select * from (Select (@rowNo :[email protected]+1) AS rowno, pwd from pur_admininfo, (Select @rowNo := 0) b) tmp where rowno=(Select Round(Rand() * 10000000 % (Select Count(*) from pur_admininfo))) limit 1;  

 

 
为了可以随机得到表结果集中的任何一条记录,这里乘以10000000,然后再取模,但不知道为什么更大的数字就不行了。
 
另一种实现方式:
 
[sql] 
SELECT * FROM pur_admininfo AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(rid) FROM pur_admininfo) - (SELECT MIN(rid) FROM pur_admininfo)) + (SELECT MIN(rid) FROM pur_admininfo)) AS rid) AS t2 WHERE t1.rid >= t2.rid ORDER BY t1.rid LIMIT 1;  

 

 
Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<