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`;

发表回复

您的电子邮箱地址不会被公开。 必填项已用 * 标注