WordPress技巧-SQL-清除草稿SQL命令

总结

用以下五条删除命令，可以清理wordpress中大部分无用的数据，测试通过直接使用

SELECT * FROM `wp_posts` WHERE `post_title`='自动草稿';
delete from wp_posts WHERE `post_title`='自动草稿';

SELECT * FROM `wp_posts` WHERE `post_name` like '%-revision-%';
delete from wp_posts WHERE `post_name` like '%-revision-%';

SELECT * FROM `wp_posts` WHERE `post_status`='auto-draft';
delete from `wp_posts` WHERE `post_status`='auto-draft';

SELECT * FROM `wp_posts` WHERE `post_type`='revision';
delete from `wp_posts` WHERE `post_type`='revision';

delete FROM wp_postmeta WHERE meta_key = '_edit_lock';
delete FROM wp_postmeta WHERE meta_key = '_edit_last';

SELECT count(ID) FROM `wp_posts`;