LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - General (http://www.linuxquestions.org/questions/linux-general-1/)
-   -   Mysql CSV problems (http://www.linuxquestions.org/questions/linux-general-1/mysql-csv-problems-252401/)

farmerjoe 11-08-2004 08:54 AM

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

trickykid 11-13-2004 08:02 AM

Well, how are you importing it?

farmerjoe 11-13-2004 11:21 AM

I am importing it through mysql command prompt.

Thanks!,
farmerjoe


All times are GMT -5. The time now is 05:56 AM.