update phome_ecms_download set titleurl=replace(titleurl,https://www.mokuge.com,http://127.0.0.1);update phome_ecms_download set titlepic=replace(titlepic,https://www.mokuge.c...
update phome_ecms_download set titleurl=replace(titleurl,https://www.mokuge.com,http://127.0.0.1);update phome_ecms_download set titlepic=replace(titlepic,https://www.mokuge.com,http://127.0.0.1); update phome_ecms_download set username=REPLACE(username,admin,发布者) WHERE id BETWEEN 1 AND 100; 指定批量修改ID=1-100;update phome_ecms_download set userid=REPLACE(userid,1,55),username=REPLACE(username,admin,改变),ismember=REPLACE(ismember,0,1) WHERE id BETWEEN 1 AND 100; 一次批量修改三个字段
发表于 2020-06-11 14:28
阅读 ( 501 )
分类:帝国cms
标签: