text: CREATE TABLE `College` (
    `ID` int(11) NOT NULL,
    `Name` varchar(100) NOT NULL,
    PRIMARY KEY (`ID`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  LOAD DATA LOCAL INFILE './College.csv' 
    INTO TABLE College 
    FIELDS TERMINATED BY ',' 
    OPTIONALLY ENCLOSED BY '"'
    LINES TERMINATED BY '\r\n'
    IGNORE 1 LINES;