Insert into TAREA_QYRIGESTER (id,F_QYNAME,F_FDDBR,F_ZCZB,F_YYZT,F_ZZJGDM,F_GSLX,F_SSHY,F_HZRQ,F_DJJG,F_RYGM,F_QYADDRESS,F_JJFW)
select
ID,
F_ENTERPRISE_NAME as '企业名称',
F_LEGAL_REPRESENT as '法人代表',
F_REGISTER_CAPTAL as '注册资本',
F_ENTERPRISE_STATUS as '企业状态',
F_ORGANIZE_CODE as '组织机构代码',
F_TYPE as '类型',
F_TRADE as '所属行业',
F_CHECK_DATE as '核准日期',
F_REGISTER_AUTHORITY as '登记机关',
F_ENTERPRISE_NUM as '企业总人数',
F_ADDRESS as '住所',
F_BUSINESS_SCOPE as '经营范围'
from
TAREA_ENTERPRISE_INFO
values的字段值 插入 insert into对应的字段
网友评论