帝国cms批量删除

delete from phome_enewsmember where userid>=2500 and userid<=3000;

 

delete from phome_enewsmember where userid>=2500 and userid<=3000;
delete from phome_enewsmemberadd where userid>=2500 and userid<=3000;

 

delete from 你的数据表前缀_enewsmember where userid>=5 and userid<=655;
delete from 你的数据表前缀_enewsmemberadd where userid>=5 and userid<=655;

 

帝国cms批量删除标题带有某字的SQL语句,比如我们要批量删除标题中带有 小王 的信息

delete from phome_ecms_表名 where title like '%小王%'

 

数据表 - 供应信息 phome_ ecms_ gongyinxinxi

delete from phome_ecms_qiugouxinxi where email='';