'[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)
);


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source