关于#数据库#的问题：反复检查过了查不出来

这个sql老提示不匹配到底咋回事啊 实在看不出来

问题相关代码
表
create table Customer
(
CustomerID varchar(50) primary key,
CustomerCompanyName nvarchar(MAX),
CustomerName nvarchar(Max),
CustomerTitle nvarchar(MAX),
CustomerAddress nvarchar(MAX),
CustomerPostalcode nvarchar(MAX),
CustomerIphone nvarchar(MAX)
)
插入语句
insert into Customer values('C001','Selead','Tom','销售经理','China','200131','11-111-1111')

列名或所提供值的数目与表定义不匹配

反复检查过了查不出来

解决这个问题

你要这么长的字段把类型改成blob试试呢
create table Customer
(
CustomerID varchar(50) primary key,
CustomerCompanyName blob,
CustomerName blob,
CustomerTitle blob,
CustomerAddress blob,
CustomerPostalcode blob,
CustomerIphone blob
)

insert into Customer (CustomerID,CustomerCompanyName ,CustomerName ,CustomerTitle ,CustomerAddress ,CustomerPostalcode ,CustomerIphone ) values('C001','Selead','Tom','销售经理','China','200131','11-111-1111')