wordpress常用SQL命令大全

-- 删除待审核文章
DELETE FROM wp_posts
WHERE post_type = 'post'
AND post_status = 'pending';

-- 可选：清理关联的元数据
DELETE FROM wp_postmeta

WHERE post_id NOT IN (SELECT ID FROM wp_posts)

	
-- 删除待审核文章 DELETE FROM wp_posts WHERE post_type = 'post' AND post_status = 'pending'; -- 可选：清理关联的元数据 DELETE FROM wp_postmeta WHERE post_id NOT IN (SELECT ID FROM wp_posts);

;