一列付给另外一列
update CIRCULATIONMC set C_NEWDATA = C_DATA
批量修改一列的内容
update CIRCULATIONMC set C_NEWDATA = replace(C_NEWDATA,'-','') where C_CODE = '010$a' or C_CODE = '011$a'
一列付给另外一列
update CIRCULATIONMC set C_NEWDATA = C_DATA
批量修改一列的内容
update CIRCULATIONMC set C_NEWDATA = replace(C_NEWDATA,'-','') where C_CODE = '010$a' or C_CODE = '011$a'