select查出数据后直接inset到另一张表

INSERT INTO system_organize
(organize_id,organize_code,organize_name)
SELECT DISTINCT REPLACE(UUID(),'-',''),a_code,a_name FROM sys_fee_a

 

REPLACE(UUID(),'-','')使用了UUID，并且把-替换掉

-----------------------------------------------------------------------------

INSERT into fee_detail
(ORGANIZE_ID,type_id,n_num,fee)
select t.orgnaize_code,t.type_code,t.n_num,t.n_money from sys_test t
LEFT JOIN
system_organize o on t.ORGNAIZE_CODE=o.ORGANIZE_CODE
LEFT JOIN
fee_type f on t.type_code=f.type_code;