LOAD DATA LOCAL INFILE with specifying first column as auto-increment value

LOAD DATA LOCAL INFILE 'index.csv'
INSERT INTO TABLE aws_pricing
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
IGNORE 6 LINES;

Thing is, my table has the first column as id int NOT NULL AUTO_INCREMENT ... PRIMARY KEY (id), so I get : > ERROR 1265 (01000): Data truncated for column 'id' at row 1 So index.csv has one column less. How do I get LOAD DATA LOCAL INFILE to work by specifying to auto-increment before reading each line from index.csv file ? MySQL Ver 8.0.32