UPDATE `wp_posts` SET `post_date` = DATE_ADD('2014-1-01', INTERVAL ROUND(RAND() * 500 + 1) DAY) WHERE `ID` between 1 AND 1402;
以上语句表示起始时间“2014-01-01”、随机日期范围“500天“
mysql给时间字段随机填充数据
最新推荐文章于 2024-05-15 01:38:41 发布
UPDATE `wp_posts` SET `post_date` = DATE_ADD('2014-1-01', INTERVAL ROUND(RAND() * 500 + 1) DAY) WHERE `ID` between 1 AND 1402;
以上语句表示起始时间“2014-01-01”、随机日期范围“500天“