复制记录的SQL查询

Question

如何将一个表的一列记录复制到另一个表的另一列

SELECT vc.crm_id, vcd.deposit_id FROM visa_card_deposit vcd
INNER JOIN deposits d on d.id = vcd.deposit_id
INNER JOIN visa_cards vc on vcd.visa_card_id = vc.id;

我现在不知道如何复制记录并将其转移到另一个表的另一列

Answer 1

您只需插入它们:

INSERT INTO my_destination_table (my_destination_columns)
SELECT vc.crm_id, vcd.deposit_id FROM visa_card_deposit vcd
INNER JOIN deposits d on d.id = vcd.deposit_id
INNER JOIN visa_cards vc on vcd.visa_card_id = vc.id;