帝国CMS数据库SQL字段替换语句
位置:首页 > 知识 > 帝国CMS 时间:2020-02-14
1.直接替换 UPDATE phome_enewsclass SET modid=REPLACE(modid,'40','17') UPDATE phome_enewsclass SET newstempid= '13',listtempid= '13' ,dtlisttempid= '13' WHERE modid='11' dtlisttempid 13 newstempid 13 listtempid 13 dtlisttempid 13 lencord 2.多列替换 UPDATE phome_enewsclass SET lencord= '25' WHERE modid='11' (浏览:次) |