Re: Another LOAD Infile Problem - Jason Ferguson - com.mysql.lists.mysql

8 messages in com.mysql.lists.mysqlRe: Another LOAD Infile Problem

From	Sent On	Attachments
Jason Ferguson	26 Sep 2005 19:57
Jasper Bryant-Greene	26 Sep 2005 20:03
Jason Ferguson	26 Sep 2005 20:07
Robert L Cochran	26 Sep 2005 20:12
Robert L Cochran	26 Sep 2005 20:18
Rory McKinley	26 Sep 2005 23:41
Jigal van Hemert	27 Sep 2005 00:14
SGr...@unimin.com	27 Sep 2005 05:50

Subject:	Re: Another LOAD Infile Problem
From:	Jason Ferguson (ferg...@gmail.com)
Date:	09/26/2005 08:07:03 PM
List:	com.mysql.lists.mysql

The data is split into about 60 files, average file size of 5 MB (varying from 1 to 10 MB). Since there are many files, I'm trying to minimize the required work (if there was just one consolidated file, no problem).

Jason

On 9/26/05, Jasper Bryant-Greene <jas...@bryant-greene.name> wrote:

Jason Ferguson wrote:

Many thanks for the earlier response to why LOAD DATA INFILE wasnt working for me. However, another problem has appeared.

In the file I am reading, 2 of the fields are SUPPOSED to be float values. However, in several places, they are set to "UNKNOWN". This seems to cause LOAD to abort.

Is there a way for me to tell it to ignore this problem and just use the default value for the column?

How about just replace occurrences of the string "UNKNOWN" in the original file with NULL (the logical equivalent) or 0 (if you're using NOT NULL columns) before doing LOAD DATA INFILE?