执行语句:
INSERT into bom.bo_approve_record
(
project_id,
approve_type,
user_id,
user_name,
remark,
opportunity_stage,
activity_id,
last_modifier_user_id,
creation_time,
creator_user_id
)
SELECT
project_id,
approve_type,
user_id,
user_name,
remark,
opportunity_stage,
activity_id,
last_modifier_user_id,
creation_time,
creator_user_id
from aom.bo_approve_record b2
where b2.project_id = 'PN20000001'
含义为将aom库下bo_approve_record 表 中project_id 为‘PN2000001’的数据复制到
bom库的bo_approve_record 表中。
--- insert into 某库.某表(字段) select(字段)from 某库.某表 where(过滤条件)
前后字段数量,顺序,格式应保持一致。
仅为一种思路,看情况使用