总结
用以下五条删除命令,可以清理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`;