--备份表create table ac01_20150105 as select * from ac01;create table ac01_dy_20150105 as select * from ac01_dy;create table cjscrz_20150105 as select * from cjscrz;--更新基本信息update ac01 t set t.yhmc = replace(t.yhmc,‘95580‘,‘96288‘) where t.photo_path like ‘%82_SBK_3_41100023_6000_20141225_4%‘ and t.yhmc = ‘95580‘;update ac01_dy t set t.yhmc = replace(t.yhmc,‘95580‘,‘96288‘) where t.photo_path like ‘%82_SBK_3_41100023_6000_20141225_4%‘ and t.yhmc = ‘95580‘;--更新采集上传日志update cjscrz t set t.yl1 = replace(t.yl1,‘95580‘,‘96288‘) where t.scpc like ‘%82_SBK_3_41100023_6000_20141225_4%‘ and t.yl1 like ‘%95580%‘;