mysql 取随机日期
SELECT FLOOR(7 + (RAND() * 6)); 取7到12的随机整数,包括7到12
select floor(12+(rand()*13)); 取12到24的随机整数,包括12到24
concat(createtime,' ',floor(12+(rand()*13)),':',floor(10+(rand()*49)),':',floor(10+(rand()*49)))
格式 : 2008-12-11 17:43:11
insert into mobilephoto(imageurl,createtime,type,updatedatetime) values('200811166.jpg','2008-11-16',1,concat(createtime,' ',floor(12+(rand()*13)),':',floor(10+(rand()*49)),':',floor(10+(rand()*49))));
|