MySql教程

mysql-查询并插入

本文主要是介绍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 -- 写条件
这篇关于mysql-查询并插入的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!