一般我們要insert table的語法是這樣
1 2 |
INSERT INTO yourTable VALUES(value1, value2) |
但如是是要把一張table的滿幾個欄位直接insert到另一張table時,可以使用下列語法
1 2 3 4 |
INSERT INTO prices (group, id, price) SELECT 7, articleId, 1.50 from article WHERE name LIKE 'ABC%' |
參考:
http://stackoverflow.com/questions/9692319/how-can-i-insert-values-into-a-table-using-a-subquery-with-more-than-one-result