You'll have to edit your input file. There will always be instances
where some field is quirky and you need to fix it/them/entire rows.
Don't expect the input file to be perfect.
I'd also suggest that you have a test database on a test machine that is
devoted entirely to getting your tables set up correctly. It saves a lot
of stress by giving you a platform to experiment on.
Bob Cochran
Jasper Bryant-Greene 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?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
