MySQL批量更改WordPress关闭和打开评论功能的方法

	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'; //批量关闭评论