wordpress 删除数据库所有文章和删除所有标签sql语句

删除所有文章

1. delete from wp_posts using wp_posts, wp_term_relationships, wp_term_taxonomy where wp_posts.id=wp_term_relationships.object_id and wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id and wp_term_relationships.term_taxonomy_id = 1

复制代码

删除所有标签

1. DELETE a,b,c
   
2. FROM wp_terms AS a
   
3. LEFT JOIN wp_term_taxonomy AS c ON a.term_id = c.term_id
   
4. LEFT JOIN wp_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
   
5. WHERE c.taxonomy = 'post_tag' AND c.count = 0

复制代码

(⊙﹏⊙) 删除数据库