mysql> select * from product order by
rand() limit 3;
+----+----------+-----------+-------------+-------------+
| id | pro_name | pro_price | pro_address | pro_content |
+----+----------+-----------+-------------+-------------+
| 1 | 衣服 | 45 | 北京 | 女式 |
| 4 | 包包12 | 438 | 北京 | 男式 |
| 2 | 包包 | 45 | 北京 | 男式 |
+----+----------+-----------+-------------+-------------+
+----+----------+-----------+-------------+-------------+
| id | pro_name | pro_price | pro_address | pro_content |
+----+----------+-----------+-------------+-------------+
| 1 | 衣服 | 45 | 北京 | 女式 |
| 4 | 包包12 | 438 | 北京 | 男式 |
| 2 | 包包 | 45 | 北京 | 男式 |
+----+----------+-----------+-------------+-------------+
3 rows in set (0.00 sec)