CMS
-
帝国CMS:一次性批量删除重复信息并保留一条的
第一步：先建立一个临时表 create table tmp as select min(id) as col1 from phome_ecms_表 group by title;
-
帝国CMS:批量去除标题图片
UPDATE phome_ecms_b SET titlepic = ”; UPDATE phome_ecms_d SET titlepic = ”; UP…
-
帝国CMS:如何清空数据表让文章id从1开始
1、文章id归零从1开始 TRUNCATE TABLE phome_ecms_news;TRUNCATE TABLE phome_ecms_news_check;TRUNCATE …
-
帝国CMS:批量设置栏目参数
UPDATE phome_enewsclass SET lencord = ’30’; 每页显示30条信息 UPDATE phome_enewsclass …
