• 懒鸟飞:帝国cms模板专业分享平台,新域名:lanniaofei.com

帝国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`='';
 
QQ在线咨询
QQ客服
淘宝官网