完整內容
web_id
把：web_ctime 隨機修改為比如要2014-月-日----2020-月-日 隨機就可以。求幫助
uj5u.com熱心網友回復：
參考這個 MySql資料庫SQL命令指定時間范圍批量修改WordPress文章發布時間 但是時間格式不一樣，不懂了。UPDATE `wp_posts` SET `post_date` = DATE_ADD('2014-1-01', INTERVAL ROUND(RAND() * 500 + 1) DAY) WHERE `ID` between 6297 AND 14332;
update `wp_posts` set `post_modified` = `post_date` WHERE `ID` between 6297 AND 14332;
update `wp_posts` set `post_date_gmt` = `post_date` WHERE `ID` between 6297 AND 14332;
update `wp_posts` set `post_modified_gmt` = `post_modified` WHERE `ID` between 6297 AND 14332;
update `wp_posts` set `post_status` = 'publish' WHERE `ID` between 6297 AND 14332
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/26211.html
標籤：基礎類
下一篇：急急急，求sql大神