wordpress通过SQL修改文章日期,-作者信息及数据库清理命令OPTIMIZE
wordpress文章修改量很大时,如果通过后台一批批处理,是不方便甚至不能实现的,这时需要用到SQL的命令。以下是文章日期及作者信息SQL命令修改方法,仅供参考。
*修改发布日期,例如始于2020-8-1,随机30天,文章ID在1000-6000之间
UPDATE`wp_posts`SET`post_status`='publish'WHERE(`post_status`='future');
UPDATE`wp_posts`SET`post_date`=DATE_ADD("2020-8-1",INTERVALROUND(RAND()*30+1)
DAY)WHERE`ID`between1000AND6000;
update`wp_posts`set`post_modified`=`post_date`WHERE`ID`between1000AND
6000;
update`wp_posts`set`post_date_gmt`=`post_date`WHERE`ID`between1000AND
6000;
update`wp_posts`set`post_modified_gmt`=`post_modified`WHERE`ID`between1000
AND6000;
*修改文章发布状态及作者信息
update`wp_posts`set`post_status`="future"WHERE`ID`between1000AND6000;
update`wp_posts`set`post_author`="1"WHERE`ID`between1000AND6000;
*执行SQL优化数据表
OPTIMIZETABLEwp_commentmeta;
OPTIMIZETABLEwp_comments;
OPTIMIZETABLEwp_links;
OPTIMIZETABLEwp_options;
OPTIMIZETABLEwp_postmeta;
OPTIMIZETABLEwp_posts;
OPTIMIZETABLEwp_terms;
OPTIMIZETABLEwp_term_relationships;
OPTIMIZETABLEwp_term_taxonomy;
OPTIMIZETABLEwp_usermeta;
OPTIMIZETABLEwp_users;
备注:语句应用时可能要修改前缀及参数,注意先备份SQL。
*修改发布日期,例如始于2020-8-1,随机30天,文章ID在1000-6000之间
UPDATE`wp_posts`SET`post_status`='publish'WHERE(`post_status`='future');
UPDATE`wp_posts`SET`post_date`=DATE_ADD("2020-8-1",INTERVALROUND(RAND()*30+1)
DAY)WHERE`ID`between1000AND6000;
update`wp_posts`set`post_modified`=`post_date`WHERE`ID`between1000AND
6000;
update`wp_posts`set`post_date_gmt`=`post_date`WHERE`ID`between1000AND
6000;
update`wp_posts`set`post_modified_gmt`=`post_modified`WHERE`ID`between1000
AND6000;
*修改文章发布状态及作者信息
update`wp_posts`set`post_status`="future"WHERE`ID`between1000AND6000;
update`wp_posts`set`post_author`="1"WHERE`ID`between1000AND6000;
*执行SQL优化数据表
OPTIMIZETABLEwp_commentmeta;
OPTIMIZETABLEwp_comments;
OPTIMIZETABLEwp_links;
OPTIMIZETABLEwp_options;
OPTIMIZETABLEwp_postmeta;
OPTIMIZETABLEwp_posts;
OPTIMIZETABLEwp_terms;
OPTIMIZETABLEwp_term_relationships;
OPTIMIZETABLEwp_term_taxonomy;
OPTIMIZETABLEwp_usermeta;
OPTIMIZETABLEwp_users;
备注:语句应用时可能要修改前缀及参数,注意先备份SQL。
精选留言