search

Home >Database >Mysql Tutorial >mysql随机读取数据库记录_MySQL

mysql随机读取数据库记录_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:36:281190browse

bitsCN.com


mysql随机读取数据库记录

 

Sql代码  

SELECT * FROM t_room WHERE fid >=   

   (((SELECT MAX(fid) FROM t_room) -(SELECT MIN(fid) FROM t_room)) * RAND() +
(SELECT MIN(fid) FROM t_room)) LIMIT 10  

 

bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql启动事件_MySQLNext article：mysql定时删除当前时间前分钟的数据_MySQL

Related articles

See more