SET@MIN ='2013-01-07 00:00:00'; SET@MAX ='2019-01-20 00:00:00'; UPDATE cms_con_articles SET date_pub = TIMESTAMPADD(SECOND, FLOOR(RAND() * TIMESTAMPDIFF(SECOND, @MIN, @MAX)), @MIN);
SET@MIN ='2013-01-07 00:00:00'; SET@MAX ='2019-01-20 00:00:00'; UPDATE cms_con_articles SET date_pub = TIMESTAMPADD(SECOND, FLOOR(RAND() * TIMESTAMPDIFF(SECOND, @MIN, @MAX)), @MIN);