帝国CMS常用SQL更新语句
摘要：帝国CMS常用SQL更新语句,使用说明,操作指南,解决方法,实用技巧,有什么用?怎样 咋样 如何 怎么设置帝国CMS常用SQL更新语句?教程免费下载.用于帝国CMS8.0,7.5,7.2,7.0
update [!db.pre!]ecms_news SET onclick = "1000";
update [!db.pre!]ecms_news SET onclick = onclick+200;
update [!db.pre!]ecms_news SET filename = pinyin WHERE classid>391 and classid<397;
update [!db.pre!]ecms_news SET filename = concat('jishu19-',pinyin) WHERE classid=29;
update [!db.pre!]enewsclass SET bname = concat(classname,'网站模板_',classname,'网页设计_网站建设公司') WHERE tbname = 'muban';
update [!db.pre!]enewsclass SET classimg = replace(classimg,'https://img.teke.cn/','/d/');
特科网
update [!db.pre!]enewsclass SET classpagekey = classname WHERE listtempid = '4';
update [!db.pre!]enewsclass SET bname = concat(classname,'网站模板',classname) WHERE listtempid = '4';
update [!db.pre!]enewsclass SET intro = concat(classname,'网站建设',classname) WHERE listtempid = '4';
特科网
update [!db.pre!]enewsclass SET classpagekey = classname WHERE tbname = 'muban';
update [!db.pre!]enewsclass SET bname = concat(classname,'网站模板',classname) WHERE tbname = 'muban' and sonclass = '';
update [!db.pre!]enewsclass SET intro = concat(classname,'网站建设',classname) WHERE tbname = 'muban' and sonclass = '';