為什么執行以下操作時出現錯誤:
INSERT INTO AnniversaryAttendees (CustomerID, PartySize) VALUES ((SELECT CustomerID FROM Customers WHERE Email="[email protected]"), ("4");
在資料庫“餐廳”上執行 SQL 查詢時出錯:輸入不完整
uj5u.com熱心網友回復:
這是因為額外的 ( 在 "4 之前?嘗試:
INSERT INTO AnniversaryAttendees (CustomerID, PartySize) VALUES ((SELECT CustomerID FROM Customers WHERE Email="[email protected]"), "4");
轉載請註明出處,本文鏈接:https://www.uj5u.com/qukuanlian/420109.html
標籤:
下一篇:根據另一個表過濾
