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
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
gt; variables, and the SET clause is supported. This enables you to assign
> input values to user variables, and then perform transformations on
> those values before assigning the result to columns."
>
> Bob: please don't top-post.
>
> Jasper
>
> > Jason
I've been over that page before posting, with no luck. It might be an
obvious error in syntax, but I can't figure it out.
Jason
On 9/26/05, Robert L Cochran <[EMAIL PROTECTED]> wrote:
>
> http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html
>
> Bob Cochran
>
&
I am attempting to import a large file with data in this format:
1923158|GA|1996 Olympic Yachting
Cauldron|park|Chatham|13|051 |320446N|0810502W|32.07944|-
81.08389Savannah
With this command:
LOAD DATA LOCAL INFILE 'C:\\PHP\\FL_DECI.txt'
INTO TABLE locations2
FIELDS TERMINATED BY '|'
LINE
