Then you are in for quite a lot of editing work. I've done it a lot
myself. Don't expect your project to be easy. Look for automated ways to
edit the data according to your needs and the actual table structure.
Bob Cochran
Jason Ferguson wrote:
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
