请选择 进入手机版 | 继续访问电脑版

【悟空资源网】

 找回密码
 注册

QQ登录

wordpress随机批量修改文章发布日期

[复制链接]
发表于 2021-10-5 20:44:07 | 显示全部楼层 |阅读模式
  1. UPDATE `wp_posts` SET `post_date` = DATE_ADD('2021-10-01', INTERVAL ROUND(RAND() * 5+ 1) DAY) WHERE `ID` between 1 AND 20000;
  2. update `wp_posts` set `post_modified` = `post_date` WHERE `ID` between 1 AND 20000;
  3. update `wp_posts` set `post_date_gmt` = `post_date` WHERE `ID` between 1 AND 20000;
  4. update `wp_posts` set `post_modified_gmt` = `post_modified` WHERE `ID` between 1 AND 20000;
  5. update `wp_posts` set `post_status` = 'publish' WHERE `ID` between 1 AND 20000;
复制代码
wordpress随机批量修改文章发布日期

数据库执行sql语句,2021-10-01这个是起始日期,在5天内随机 ,1 AND 20000 这个是数据库中的wp内容id,在1到20000中间将日期随机,wp_posts是表名,如前缀修改,需要把wp修改成你所设置的前缀
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

Archiver|手机版|【悟空资源网】 ( 桂ICP备2022002215号-1 )

GMT+8, 2024-3-29 02:51 , Processed in 0.056678 second(s), 25 queries .

Powered by Discuz! X3.4 Licensed

© 2001-2012 Comsenz Inc. Template by A3cn

返回顶部