数据库技能实战进阶之常用结构化sql语句(中)
select *from userorder by rand();5 linux 0
8 LInux redis
15 python javadocker
16 LInux
2 LInuxmysql NULL
7 kailinux javadocker
28 winner1234
20 centos
17 linux 999
6 redis name
3 python NULL
26 redispyhon
22 rediswinner
25 PYTHoREDIS
27 PYthon234
这种随机数里面就可以用来抽奖之类的,我们将随机排序的再获取3行,
select *from userorder by rand() limit 3;
23 PYthonmysql
27 PYthon234
4 LInux redis
页:
[1]