search

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

数据库获取随机记录_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:29:181026browse

bitsCN.com


数据库获取随机记录

 

随机记录随机数

 

1. mysql :SELECT * FROM Member WHERE Country = "HK" ORDER BY RAND() limit 302. oracle : select id from tableName where rownum<100 order by dbms_random.value

 


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 grant语法的详细解析(帐号权限管理)_MySQLNext article：mysql备份：完全备份和增量备份_MySQL

Related articles

See more