1.语法
INSERT INTO 要插入的表 (
字段1,
字段2,
......
)
SELECT
字段1,
字段2,
......
FROM 查询的数据表
WHERE 条件
2.实例
例如往数据库DB中的sys_persion表中插入sys_user表中男性(1)的数据
INSERT INTO `sys_person` (
id,
orgId,
orgName,
departmentId,
`name`,
createTime,
isEnable,
`type`,
regionId,
regionName,
regionCode,
dataLevel,
provinceRegionId,
cityRegionId,
countryRegionId,
countrysideRegionId,
villageRegionId,
phone,
userid
)
SELECT
id,
orgId,
orgName,
departmentId,
`name`,
createTime,
isEnable,
`type`,
regionId,
regionName,
regionCode,
dataLevel,
provinceRegionId,
cityRegionId,
countryRegionId,
countrysideRegionId,
villageRegionId,
tel,
userid
FROM `sys_user`
WHERE sex = 1
3.注意事项
注意类型和插入查询的长度