WordPress删除数据库所有文章和删除所有标签sql语句
删除所有文章
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
删除所有标签
DELETE a,b,c
FROM wp_terms AS a
LEFT JOIN wp_term_taxonomy AS c ON a.term_id = c.term_id
LEFT JOIN wp_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
WHERE c.taxonomy = 'post_tag' AND c.count = 0




![1200G大盘实例[超大硬盘区] 核心骨干网络优化线路,全国平均延时低至25ms](http://youxi.010173.com/static/wy/img/gg-4.png)







