AUTO INCREMENT of primary key not working

[mark roles]

With the following code successfully executed:

CREATE TABLE `outback`.`JUN7`(
FM_Id int(6) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (FM_Id),
COLOR VARCHAR(10),
SN VARCHAR(10));

I then do a LOAD DATA INFILE of a file that just contains the following:

RED,1234567890

I get the error message of:
Incorrect integer value: 'RED' for column 'FM_ID' at row 1.

What am I missing to have it auto populate my PRIMARY KEY of FM_Id?