帝国cms用sql批量删除内容为空的文章

DELETE FROM `phome_ecms_news_index` WHERE `id` IN (SELECT id FROM `phome_ecms_news_data_1` WHERE `newstext`='');
DELETE FROM `phome_ecms_news` WHERE `id` IN (SELECT id FROM `phome_ecms_news_data_1` WHERE `newstext`='');
DELETE FROM `phome_ecms_news_data_1` WHERE `newstext`='';

 

声明：所有帝国CMS免费模板注册会员后均可下载，如有侵权，请联系客服，我们会在12小时内处理！