帝国cms怎么批量删除不带缩略图的文章

帝国cms批量删除不带缩略图的文章

delete from bazhepu_ecms_news where titlepic = '' ;

然后再对齐

delete from bazhepu_ecms_news_index where id not in(select id from phome_ecms_news);
delete from bazhepu_ecms_news_data_1 where id not in(select id from phome_ecms_news)

注意：所有关于数据库的操作一定要现备份！备份！备份！备份！

SQL命令中的bazhepu换成你自己的数据库的前缀