I am trying to import some data from a csv file into a mysql table using the LOAD DATA LOCAL INFILE command as below;

```
DROP TABLE IF EXISTS rctemp;
CREATE TABLE IF NOT EXISTS rctemp (`region` varchar(32) NOT NULL,
  `reportSuite` varchar(32) NOT NULL,
  `PageImpressions` int(11) NOT NULL,
  `UniqueUsers` int(11) NOT NULL);

LOAD DATA LOCAL INFILE 'main.csv'
INTO TABLE rctemp
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
(region, reportSuite, PageImpressions ,UniqueUsers);

```

The sql runs and produces no errors when run from command line but it doesn't insert any data into the table. It creates the table perfectly fine but fails to add any data from the csv.