MYSQL随机抽取数据库里的几条数据

我不是鱼

UID: 2
帖子: 1402
积分: 3221
在线时间: 2077小时
注册时间: 2006-05-16
最后登录: 2019-01-15

1^# 我不是鱼发表于2006-09-01

MYSQL随机抽取数据库里的几条数据

mysql> use discuz;
Database changed

mysql> select username from cdb_members order by rand() limit 0,5;
+--------------+
| username    |
+--------------+
| hahamimi    |
| hyp323    |
| zjh00958    |
| 梦有知    |
| winteralways |
+--------------+
5 rows in set (0.03 sec)

mysql> select username from cdb_members order by rand() limit 0,5;
+-----------+
| username  |
+-----------+
| setnm2003 |
| Raymond |
| nyyjy010  |
| 290500231 |
| samtian |
+-----------+
5 rows in set (0.00 sec)

mysql> select username from cdb_members order by rand() limit 0,5;
+-------------+
| username |
+-------------+
| ly2008    |
| tellgkkg |
| 1502050124  |
| powershot |
| adriftcloud |
+-------------+
5 rows in set (0.00 sec)

mysql> select username from cdb_members order by rand() limit 0,5;
+-----------+
| username  |
+-----------+
| Takeshi |
| icelong |
| 狗狗请罪  |
| 菜头    |
| weike1130 |
+-----------+
5 rows in set (0.01 sec)

mysql> select username from cdb_members order by rand() limit 0,5;
+----------+
| username |
+----------+
| 菜头    |
| romeoqq  |
| hahamimi |
| 青玫瑰 |
| lmhllr |
+----------+
5 rows in set (0.00 sec)

mysql>

如履薄冰

sjethc

UID: 23157
帖子: 4
积分: 0
在线时间: 1小时
注册时间: 2008-05-26
最后登录: 2009-07-02

2^# sjethc 发表于2009-06-13

看不懂

只知道是在命令行下