帝国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`='';
![帝国ECMS修改[!–newsnav–]导航样式(面包屑导航)](/d/file/ecms/2016-11-02/a871d0b11b000b92f373781413d47fb4.jpg)

