select a,sys_guid() as b from mytable
sys_guid() 是生成带分隔符(-)的GUID的自定义函数
查询B表的内容插入A表,MY_ID是A表的主键不可为空,因此需要B查询出来的数据增加一列并且赋值插入A
insert into A (plan_id,ship_id,MY_ID)
select plan_id,ship_id,sys_guid() as myMonthID from B
select a,sys_guid() as b from mytable
sys_guid() 是生成带分隔符(-)的GUID的自定义函数
查询B表的内容插入A表,MY_ID是A表的主键不可为空,因此需要B查询出来的数据增加一列并且赋值插入A
insert into A (plan_id,ship_id,MY_ID)
select plan_id,ship_id,sys_guid() as myMonthID from B
转载于:https://www.cnblogs.com/hhmm/p/9139957.html