MySQL Insert random date

20150510 Insert a random date add_time (int) in the table, 2014 random dates, preferably every month

Due to the time stamp format stored, one months difference 2678400, a day difference of 86400

The function to use

SELECT unix_timestamp (' 20141231 ') #1419955200

SELECT from_unixtime (1391675501, '%y%m%d%h:%i:%s ')

SELECT Floor (1 + (RAND () *)) #随机月份

SELECT Floor (1 + (RAND ())) #随机天数

SELECT Floor (1 + (RAND () * 86400)

UPDATE ' hhy_store_copy ' SET add_time= (SELECT 1419955200-(Floor (1 + (RAND) *) *2678400)-(Floor (1 + (rand () * 31)) *8640 0)-floor (1 + (RAND () * 86400))) WHERE Add_time is NULL

MySQL Insert random date