我有这个表:
CREATE TABLE Vendors ( VendorID NUMERIC(10) NOT NULL,VendorName CHAR(50) NOT NULL,VendorAddress VARCHAR(30) NULL,VendorCityName VARCHAR(20) NOT NULL,VendorStateName CHAR(2) NOT NULL,VendorZip VARCHAR(10) NULL,VendorContactName CHAR(50) NOT NULL,VendorContactPhone VARCHAR(12) NOT NULL,VendorContactEmail VARCHAR(20) NOT NULL,VendorSpecialty CHAR(20) NOT NULL CONSTRAINT VendorsPK PRIMARY KEY (VendorID) );
并插入:
INSERT INTO Vendors(VendorID,VendorName,VendorAddress,VendorCityName,VendorStateName,VendorZip,VendorContactName,VendorContactPhone,VendorContactEmail,VendorSpecialty) VALUES(151330,'Hyperion','77 West 66th Street','New York','NY',10023,'John Hinks','212-337-6564','jhinks@hyperionbooks.com','Popular fiction')
为什么这个语句会产生8152错误?