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 <[EMAIL PROTECTED]> 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? > > -- > Jasper Bryant-Greene > Freelance web developer > http://jasper.bryant-greene.name/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >