I regularly import CSV files into MySQL and sometimes the program that creates them has a random number of ” characters in the last line. I’d like to ignore this line when it occurs. Is there a way to deal with this when using the LOAD DATA statement?

I’ve reviewed the MySQL documentation for the LOAD DATA statement and I didn’t see any obvious options that would help address my problem.