2張table的value copy

239 月 2014 by Bryce No Comments

一般我們要insert table的語法是這樣

INSERT INTO yourTable 
VALUES(value1, value2)

1 2	INSERT INTO yourTable VALUES(value1, value2)

但如是是要把一張table的滿幾個欄位直接insert到另一張table時，可以使用下列語法

INSERT INTO prices (group, id, price) 
SELECT 7, articleId, 1.50
from article 
WHERE name LIKE 'ABC%'

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