登录数据库管理phpmyadmin，选择需要修改的数据库，-sql

提醒：执行前务必备份数据库！执行前务必备份数据库！执行前务必备份数据库！

Wordpress如何批量删除某个分类下的所有文章，先执行查询，后执行删除：

SELECT * FROM `wp_posts`,`wp_term_relationships` WHERE wp_posts.ID = wp_term_relationships.object_id AND wp_term_relationships.term_taxonomy_id = [category_id];

DELETE `wp_posts` FROM `wp_posts`, `wp_term_relationships` WHERE wp_posts.ID = wp_term_relationships.object_id AND wp_term_relationships.term_taxonomy_id = [category_id];

将指定分类下的文章状态改为 私密 的：

UPDATE wp_posts

INNER JOIN wp_term_relationships ON wp_posts.ID = wp_term_relationships.object_id

SET wp_posts.post_status = 'private'

WHERE wp_term_relationships.term_taxonomy_id = [category_id];

批量删除私密文章中某个指定分类中的所有文章

DELETE wp_posts FROM wp_posts

INNER JOIN wp_term_relationships ON wp_posts.ID = wp_term_relationships.object_id

WHERE wp_posts.post_status = 'private'

AND wp_term_relationships.term_taxonomy_id = [category_id];

使用 MySQL 命令删除 WordPress 中的所有草稿文章