mysql - 如果我有一个 select 语句，如何轻松地将其分解为 mysql 中的 insert 语句？

Question

示例:

select * 
from 
  component 
inner join 
  component_supplier on component.id = component_supplier.component_id
inner join 
  supplier on supplier.id = component_supplier.supplier_id
where 
  component_supplier.supplier_part_no = ".048_CR_SHT_A1008_CS_TP_ B_4ftx8ft"

我想获取这些数据并将其切碎并将其塞入另一个表中，如下所示:

  INSERT into sugarcrm2.jce_components jce_c(   
    id,
    name,
    part_no_id,
    part_no,
    cost,
    lead,
    qty,   
    units,   
    class,   
    category,   
    notes ) 
  VALUES(   
    a bunch of different values that I get from that first select. 
  )

Answer 1

INSERT 可以采用以下形式:

INSERT INTO TABLE2(A,B,C) 
SELECT A, B, C 
FROM TABLE1 
INNER JOIN...