1 year ago
#388768
user17383560
[42S22][1054] Unknown column 'boatType' in 'field list'
INSERT INTO BOAT(VID, name, yearBuilt, boatType, numBeds, TEUs)
VALUE (10, 'John', '1988-02-05', 'YACHT', 24, NULL);
CREATE TABLE BOAT (
VID INT NOT NULL,
name varchar(20),
yearBuilt DATE,
boatType ENUM ('YACHT', 'CARGO SHIP', 'NULL'),
numBeds INT,
TUEs INT,
PRIMARY KEY (VID)
);
mysql
database
0 Answers
Your Answer