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