MySQL 随机查询数据与随机更新数据实现代码

复制代码 代码如下:

SELECT * FROM table_name ORDER BY rand() LIMIT 5;

复制代码 代码如下:

MySQLl> select RAND();
-> 0.5925
MySQLl> select RAND(20);
-> 0.1811
MySQLl> select RAND(20);
-> 0.1811
MySQLl> select RAND();
-> 0.2079
MySQLl> select RAND();
-> 0.7888

复制代码 代码如下:

UPDATE cdb_posts SET views = rand();

复制代码 代码如下:

SELECT * FROM `table` ORDER BY RAND() LIMIT 5