WordPress删除文章修订版本和自动保存的草稿

分享时间:2020-03-08
删除所有文章的修订版:

DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = 'revision';
删除自动保存的草稿:

DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_status = 'auto-draft';
本文地址:http://www.aizhanku.com/t39509

本文标签:

 
 
 
《手游变态盒子》破解版本下载
                     
手游公益服盒子
点击下载领取新版本礼包 高速下载获取更多活动福利

需优先下载游戏盒子

    返回顶部