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 里随机生成时间