MySQL 批量修改时间
update tb_article set created_at=date_add(created_at,interval+600 day);

update wp_posts set post_date=date_add(post_date,interval+600 day);
update wp_posts set post_date_gmt=date_add(post_date_gmt,interval+600 day);
update wp_posts set post_modified=date_add(post_modified,interval+600 day);
update wp_posts set post_modified_gmt=date_add(post_modified_gmt,interval+600 day);

update wp_posts set post_date_gmt=post_date where 1;

select ID, post_date, post_title from wp_posts where post_date>'2023-01-01 12:12:00';

update wp_posts set post_date_gmt=post_date where 1;

update wp_posts set post_date=date_add(post_date,interval+300 day)
where post_date>'2023-01-01 12:12:00' and post_date<'2024-01-01 12:12:00';

update wp_posts set post_date=date_add(post_date,interval-300 day)
where post_date>'2023-01-01 12:12:00' and post_date<'2030-01-01 12:12:00';

update wp_posts set post_date=date_add(post_date,interval+300 day)
where post_date>'2023-01-01 12:12:00' and post_date<'2024-01-01 12:12:00';
声明:本站所有文章和图片,如无特殊说明,均为原创发布。商业转载请联系作者获得授权,非商业转载请注明出处。
随机推荐
Web 自定义组件
WordPress 修改 RESTful API 的请求和响应
Node.js zlib 模块
JavaScript 私有方法和私有属性
WordPress 添加自定义接口
WordPress 函数 get_categories() 获取所有分类
JavaScript 和 CSS 检测横屏适配
Linux 网络流量监控 iftop