Mysql CSV problems
 

Is there a simple way I can ignore incomplete entries when importing from a CSV in mysql?

For example:

I would want to ignore this entier line in the CSV file because it didnt contain COMPLETE information in field 3.

test;test2;;test4;test5;test6


Thanks!
-Farmerjoe

Well, how are you importing it?

I am importing it through mysql command prompt.

Thanks!,
farmerjoe