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

帝国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`='';
上一篇 帝国cms自带采集和火车头采集器的优缺点对比 下一篇 帝国cms高铁采集器/火车头采集器下载模型downpath多值字段免登录发布接口写法