Sql无法执行查询。错误：'phone'附近的语法不正确。 'phone'附近的语法不正确。 'phone'附近语法不正确 [英] Sql failed to execute query. Error: incorrect syntax near 'phone'. Incorrect syntax near 'phone'. Incorrect syntax near 'phone'
本文介绍了Sql无法执行查询。错误：'phone'附近的语法不正确。 'phone'附近的语法不正确。 'phone'附近语法不正确的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
这是我的代码：
this is my code:
CREATE TABLE Customers (
CustomerID varchar(25) NULL,
LastName varchar(20) NULL,
FirstName varchar(35) NULL,
EmailAddress varchar(35) NULL,
Address varchar(35) NULL,
City varchar(25) NULL,
State varchar(15) NULL,
ZIP varchar(5) NULL,
Country varchar(20) NULL,
HomePhone varchar(15) NULL,
MobilePhone varchar (15) NULL,
Fax int NULL,
CouponCustomer varchar(5) Null,
);
INSERT INTO Customers (CustomerID, LastName, FirstName, EmailAddress, Address, City, State, ZIP, Country, Home Phone, Mobile Phone, Fax, Coupon Customer) VALUES ('1', 'Wacker', 'Roland', ‘Rwak@gmailz.com’, ‘123 10th Street’, ‘Chicago’, ‘IL’, ‘99999’, ‘USA’, ‘416598563’, ‘416598564’, ‘(123)555-0101’, ‘Yes’ );
我尝试过：
我尝试删除单引号并通过家庭电话和手机将int更改为varchar
What I have tried:
I tried removing single quotations and changing int by home phone and mobile phone to varchar
推荐答案
您应该在字段名称中尝试不带空格：
You should try without space in fields names:
...
HomePhone varchar(15) NULL,
MobilePhone varchar (15) NULL,
...
INSERT INTO Customers (CustomerID, LastName, FirstName, EmailAddress, Address, City, State, ZIP, Country, HomePhone, MobilePhone, Fax, Coupon Customer) VALUES ('1', 'Wacker', 'Roland', ‘Rwak@gmailz.com’, ‘123 10th Street’, ‘Chicago’, ‘IL’, ‘99999’, ‘USA’, ‘416598563’, ‘416598564’, ‘(123)555-0101’, ‘Yes’ );
这篇关于Sql无法执行查询。错误：'phone'附近的语法不正确。 'phone'附近的语法不正确。 'phone'附近语法不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
