insert into ktz_xy(dldm) select tdfldm1.dldm from tdfldm1 order by tdfldm1.id
将tdfldm1表中的dldm 列导入ktz_xy表的dldm列.
如果是这样加了括号会报错,去掉order by则不会,奇怪
insert into ktz_xy(dldm) (select tdfldm1.dldm from tdfldm1 order by tdfldm1.id)
insert into ktz_xy(dldm) select tdfldm1.dldm from tdfldm1 order by tdfldm1.id
将tdfldm1表中的dldm 列导入ktz_xy表的dldm列.
如果是这样加了括号会报错,去掉order by则不会,奇怪
insert into ktz_xy(dldm) (select tdfldm1.dldm from tdfldm1 order by tdfldm1.id)