gpt4 book ai didi

mysql - 第 3 行的 mysql 语法问题,不确定代码有什么问题

转载 作者:行者123 更新时间:2023-11-29 04:16:44 26 4
gpt4 key购买 nike

格式化以更好地显示。

INSERT INTO Customers (CustomerName, CustomerDeliveryAddress, CustomerPhone, CustomerBillingAddress, CustomerCreditCard)
VALUES ('Kristin Foster', '3109 Station St, Austin, TX', '512-443-9548', '3109 Station St, Austin, TX', '1234 5678 9012 3456')
('John May', '539 Brentwood Dr, Austin, TX', '512-345-9284', '539 Brentwood Dr, Austin, TX', '2345 6789 0123 4567')
('Margie Webb', '3639 Sundown Ln, Elgin, TX', '512-594-6836', '3639 Sundown Ln, Elgin, TX', '3456 7890 1234 5678')
('Barry Allen', '3082 Cemetery St, Round Rock, TX', '906-358-1958', '3082 Cemetery St, Round Rock, TX', '4567 8901 2345 6789')

最佳答案

每组值后缺少逗号

INSERT INTO Customers (CustomerName, CustomerDeliveryAddress, 
CustomerPhone, CustomerBillingAddress, CustomerCreditCard)
VALUES
('Kristin Foster', '3109 Station St, Austin, TX',
'512-443-9548', '3109 Station St, Austin, TX', '1234 5678 9012 3456') ,
('John May', '539 Brentwood Dr, Austin, TX',
'512-345-9284', '539 Brentwood Dr, Austin, TX', '2345 6789 0123 4567'),
('Margie Webb', '3639 Sundown Ln, Elgin, TX',
'512-594-6836', '3639 Sundown Ln, Elgin, TX', '3456 7890 1234 5678'),
('Barry Allen', '3082 Cemetery St, Round Rock, TX',
'906-358-1958', '3082 Cemetery St, Round Rock, TX', '4567 8901 2345 6789')

关于mysql - 第 3 行的 mysql 语法问题,不确定代码有什么问题,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/40851273/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com