insert into jwxt.jy_zyxx a (a.jxjhh,
a.ssxqdm,
a.nj,
a.zydm,
a.xklbdm,
a.rs,
a.bjs,
a.zskcs,
a.zdbyxf,
a.ggbxxf,
a.ggxxxf,
a.xkbxxf,
a.xkxxxf,
a.zybxxf,
a.zyxxxf1,
a.zyxxxf2,
a.sjkxf,
a.fssjxf,
a.jqsjxf,
a.yyfjxf,
a.kwxf,
a.tsbxxf,
a.tsxxxf,
a.dlbxxf,
a.flxxxf,
a.knsyxf,
a.dexwxf,
a.bybz,
a.xwsybz,
a.gxkxf,
a.xxysyzdxf,
a.whkcxf,
a.kjwhkcxf,
a.yskcxf,
a.xxfyq,
a.xynx,
a.fxnx,
a.bz,
a.zt,
a.gxkcxf,
a.kcly2,
a.kcly3,
a.kcly4,
a.kcly5,
a.kcly6,
a.kcly7,
a.kcly8,
a.kcly9,
a.kcly10,
a.kcly1
) select
'2014' || substr(b.jxjhh,5,4), 字符串的连接与截取
b.ssxqdm,
'2014',
b.zydm,
b.xklbdm,
b.rs,
b.bjs,
b.zskcs,
b.zdbyxf,
b.ggbxxf,
b.ggxxxf,
b.xkbxxf,
b.xkxxxf,
b.zybxxf,
b.zyxxxf1,
b.zyxxxf2,
b.sjkxf,
b.fssjxf,
b.jqsjxf,
b.yyfjxf,
b.kwxf,
b.tsbxx