INSERT INTO
`base_company_delivery_address`
(`create_time`, `create_user`, `update_time`, `update_user`, `is_valid`,
`company_id`, `address_info`, `electric_fence_id`, `point_type`, `address_short`,
`province`, `city`, `district`, `contact`, `phone`, `delivery_instructions`)
select
NOW() as create_time,
5001504 as create_user,
NOW() as update_time,
5001504 as update_user,
1 as is_valid,
company_id,
address as address_info,
0 as electric_fence_id,
0 as point_type,
address_short,
province,
city,
district,
people as contact,
phone,
info as delivery_instructions
from tmp_address
where 条件
复杂
INSERT INTO table1(field1,field2,field3,field4,field5)
select a.field1,a.field2,a.field3,b.field4,b.field5 from table2 as a
left join table3 as b on a.filed = b.filed
where -- 写条件