update Events_Dev set Events_Dev.EventTime=concat(‘2016-08-‘,floor(9+rand()*10),‘ ‘,floor(10+rand()*10),‘:‘,floor(10+rand()*49),‘:‘,floor(10+rand()*49)) where Events_Dev.DevId=‘000ADA0C29534243‘;
mysql 里随机生成时间
原文：http://www.cnblogs.com/adjk/p/5899091.html
