我有兩張表，一張PLAYERS用這種結構呼叫：
PLAYERS (name, team, goals, cod)
另一個NEW_PLAYERS用這種結構呼叫：
NEW_PLAYERS (name, team, goals)
我想將值插入NEW_PLAYERS到為所有PLAYERS的暫存器設定值 1中。codNEW_PLAYERS
我認為這段代碼可以作業，但事實并非如此。
INSERT INTO PLAYERS (name, team, goals, cod)
VALUES ((SELECT name, team, goals FROM NEW_PLAYERS), 1);
有沒有人有更好的選擇？
uj5u.com熱心網友回復：
你快到了。嘗試這個。
INSERT INTO PLAYERS(name,team,goals,cod)
SELECT name,team,goals,1 FROM NEW_PLAYERS
uj5u.com熱心網友回復：
INSERT ... SELECT不使用 INSERT ... VALUES
INSERT INTO PLAYERS(name,team,goals,cod)
SELECT n.name
, n.team
, n.goals
, 1 AS cod
FROM NEW_PLAYERS n
ORDER BY 1,2,3
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/436648.html
標籤：sql