mysql - mysql中表与表之间如何传输数据

Question

我想将数据从一个表传输到另一个表，并且我想在第二个表中添加一个附加列。

INSERT INTO invoiceitem(invoiceno, barcode, itemname, quantity, unitprice, subamount)
VALUES
    ('$Succ2', SELECT barcode, resultname, quantity, resultprice, subamount)
FROM test;

Answer 1

如果要将值从一个表插入到另一个表，则无需在插入查询中使用 VALUES。请引用INSERT TABLE TO ANOTHER TABLE

INSERT INTO invoiceitem (invoiceno, barcode, itemname, quantity, unitprice, subamount)
SELECT '$Succ2' barcode, resultname, quantity, resultprice, subamount
FROM test;