Re: Load data infile help

[Rick James]

If your CSV file consistently has 5 columns, but your table has 7 columns, then look at the LOAD command to see how to load only the 5 columns and ignore the other 2 columns.

If you are saying that the table currently has 5 columns, but new data (and CSV) has 7 columns, then consider this:
0. Create a new table with the two new columns (plus id for joining to original table)
1. LOAD the CSV into a temporary table with 7 columns.
2. INSERT ... SELECT to copy the 5 columns into the main table.
3. INSERT ... SELECT to copy the 2 columns into the new table.