1 year ago

#388768

test-img

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

Accepted video resources