MySQL Error Code 1054-插入数据不成功

Question

我需要MySQL程序的帮助，这是代码:

INSERT INTO CUSTOMER (Customerid, CustomerFname, CustomerLname, CustomerPhone, CustomerGender, CustomerYearly_salary, CustomerStreet, CustomerCity, CustomerState, CustomerPostcode, ProductId, PaymentId)
VALUES (12345678910,’Anna’, ’English’, 017362930115, ‘female’, 30000, ‘Augsburger_Str._84‘, ‘Senscheid’, ‘Rheinland-Pfalz’, 53520, 0101, 50000)

这是错误代码:

INSERT INTO CUSTOMER (Customerid、CustomerFname、CustomerLname、CustomerPhone、CustomerGender、CustomerYearly_salary、CustomerStreet、CustomerCity、CustomerState、CustomerPostcode、ProductId、PaymentId)VALUES (12345678910， ' Anna '， ' English '， 017362930115， ' female '， 30000， ' Augsburger_Str. ');_84 '， ' Senscheid '， ' Rheinland-Pfalz '， 53520,0101, 50000)

错误码:1054。"字段列表"中未知列"Anna">

Answer 1

根据错误消息，SQL认为Anna(和前面的其他值)是列，用引号替换:

INSERT INTO CUSTOMER (Customerid, CustomerFname, CustomerLname, CustomerPhone, CustomerGender, CustomerYearly_salary, CustomerStreet, CustomerCity, CustomerState, CustomerPostcode, ProductId, PaymentId);
VALUES (12345678910, 'Anna', 'English', 017362930115, 'female', 30000, 'Augsburger_Str._84', 'Senscheid', 'Rheinland-Pfalz', 53520, 0101, 50000);