以下内容为程序代码:
1 select Mid(cplx,1,Instr(cplx,":")-1)+Mid(tclx,1,Instr(tclx,":")-1)+Mid(eddy,1,Instr(eddy,":")-1)+Mid(ypccdm,1,Instr(ypccdm,":")-1)+jx+wdtx+drlz+Mid(rldj,1,Instr(rldj,":")-1)+Mid(jj,1,Instr(jj,":")-1)+Mid(jjcd,1,Instr(jjcd,":")-1)+Mid(bzlx,1,Instr(bzlx,":")-1)+Mid(hb,1,Instr(hb,":")-1)+Mid(xjcz,1,Instr(xjcz,":")-1)+Mid(bf,1,Instr(bf,":")-1) f-rom {产品表}
老师,如上代码我执行SQL语句是可以的,我想把执行结果作为新列放到产品表中应该如何处理?