WordPress按文章分类删除文件sql语句
 时间 :
          2021-09-30  
          编辑 :admin 
        对数据库进行sql操作前,请先对数据库进行备份,一定要有备份数据的好习惯!
先检查下数据是否一致,将以下命令中的47替换成你准备删除文章所在分类的ID
SELECT * FROM `wp_posts`,`wp_term_relationships` WHERE wp_posts.ID = wp_term_relationships.object_id AND wp_term_relationships.term_taxonomy_id = 128;
然后进行删除
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 = 128
 
 