帝国cms用sql批量删除内容为空的文章,用下面的的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`='';