MySQL批量更改WordPress关闭和打开评论功能的方法
时间:2014-12-11 01:03 来源:linux.it.net.cn 作者:IT
use wordpressDB;
select * from wp_posts where post_title="终端服务器超出了最大允许连接";
select * from wp_posts where post_title="ubuntu关闭图形界面";
set sql_safe_updates=0;
UPDATE wp_posts SET comment_status='open' where post_title="终端服务器超出了最大允许连接";
set sql_safe_updates=1;
select post_title,comment_status,ping_status from wp_posts where comment_status="closed"; //查看
set sql_safe_updates=0;
UPDATE wp_posts SET comment_status='open'; //批量打开评论
set sql_safe_updates=1;
UPDATE wp_posts SET comment_status='closed'; //批量关闭评论
(责任编辑：IT)
use wordpressDB;
select * from wp_posts where post_title="终端服务器超出了最大允许连接";
select * from wp_posts where post_title="ubuntu关闭图形界面";
set sql_safe_updates=0;
UPDATE wp_posts SET comment_status='open' where post_title="终端服务器超出了最大允许连接";
set sql_safe_updates=1;
select post_title,comment_status,ping_status from wp_posts where comment_status="closed"; //查看
set sql_safe_updates=0;
UPDATE wp_posts SET comment_status='open'; //批量打开评论
set sql_safe_updates=1;
UPDATE wp_posts SET comment_status='closed'; //批量关闭评论
(责任编辑：IT) |