Thread: Mysql如何用rand()生成随机数?
View Single Post
  #1   IP: 114.238.173.71
Old 2014-11-26, 04:59 PM
Radnor Radnor is offline
初级会员
  
Join Date: 2014-03-28
Posts: 1
Radnor 现在声名狼藉
Default Mysql如何用rand()生成随机数?
ceil(rand()*10); 生成1位随机数
ceil(rand()*100);生成2位随机数
ceil(rand()*1000);生成3位随机数
ceil(rand()*10000);生成4位随机数
ceil(rand()*100000);生成5位随机数
ceil(rand()*1000000);生成6随机数
Reply With Quote