I am trying to load a delimited flat file with four columns into a new table that I created with an auto_increment column as the first column. How do I load the incoming data into columns 2, 3, 4, and 5 while MySQL automatically assigns the value for the auto_increment column?

Thanks!
Ray