mysql生成随机时间
mysql> update test set create_time=concat('2013-10-01 ', floor(10+rand()*10),':',floor(10+rand()*49),':',floor(10+rand()*49)) where create_time='0000-00-00 00:00:00';
Query OK, 1 row affected
Rows matched: 1 Changed: 1 Warnings: 0
http://www.htsjk.com/shujukunews/1975.html
www.htsjk.Com
true
http://www.htsjk.com/shujukunews/1975.html
NewsArticle
mysql生成随机时间 mysql update test set create_time=concat(2013-10-01 , floor(10+rand()*10),:,floor(10+rand()*49),:,floor(10+rand()*49)) where create_time=0000-00-00 00:00:00;Query OK, 1 row affectedRows matched: 1 Changed: 1 Warnings...
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。