mysql-查询并插入

数据库-查询并插入

简单

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 -- 写条件