CREATE TABLE my_Category
(
    catCode VARCHAR(3) NOT NULL,
    catName VARCHAR(12) NOT NULL,
        PRIMARY KEY (catCode)
);


LOAD DATA LOCAL INFILE "categories.csv" INTO TABLE my_Category FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 ROWS;
