sql

(2007-03-23 17:56:42)    水天一色(153466655)
把img_logo/user/face/default.jpg和img_logo/user/face/defaults.gif、/img_logo/guild/guild.jpg拷到图片服务器上的相应文件夹

 

去掉第一个'/'并在其前加上'{ImgServer1}'
update user_info set user_face = '{ImgServer1}' + substring(user_face,2,len(user_face))

update theme set logo_l = '{ImgServer1}img_logo/theme/' + logo_l, logo_m = '{ImgServer1}img_logo/theme/' + logo_m, logo_s = '{ImgServer1}img_logo/theme/' + logo_s
update theme_group set logo_l = '{ImgServer1}img_logo/theme/' + logo_l, logo_m = '{ImgServer1}img_logo/theme/' + logo_m, logo_s = '{ImgServer1}img_logo/theme/' + logo_s

update station set logo_l = '{ImgServer1}' + substring(logo_l,2,len(logo_l)),logo_m = '{ImgServer1}' + substring(logo_m,2,len(logo_m)),logo_s = '{ImgServer1}' + substring(logo_s,2,len(logo_s))
update notice set notice_image = '{ImgServer1}' + substring(notice_image,2,len(notice_image))
update Ad_Record set RecordImage = '{ImgServer1}' + substring(RecordImage,2,len(RecordImage))
update guild set guild_logo = '{ImgServer1}' + substring(guild_logo,2,len(guild_logo))

update action_date set act_img = '{ImgServer1}' + substring(act_img,4,len(act_img))