|
|
|||||||
 |
|
|
Thread Tools | Display Modes |
|
|
|
#1
IP: 112.87.30.158
2015-04-19, 08:54 AM
|
|||
|
|||
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)))); 
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| MySQL毫秒值和日期的指定格式的相互转换 | Kaitlin | MySQL | 0 | 2015-04-18 11:01 PM |
| mysql 帮助文档使用 | Haddam | MySQL | 0 | 2014-11-26 06:43 PM |
| 如何导入导出MySQL数据库 | topvip | 建站交流 | 0 | 2006-10-10 07:43 AM |
| mysql安装与简单使用 | sunshine | 服务器环境搭建 | 0 | 2006-01-11 07:29 PM |
| winxp下安装全新的apache,php(5.0),mysql(5.0)... | topvip | 服务器环境搭建 | 0 | 2006-01-08 10:28 PM |
Hybrid Mode
