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 '|'
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
Jason Ferguson wrote:
I am
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 Ferguson wrote:
I am attempting to import a large file with data in this format:
1923158|GA|1996 Olympic Yachting
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
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