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 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.08389||||||||Savannah > > > >With this command: > >LOAD DATA LOCAL INFILE 'C:\\PHP\\FL_DECI.txt' > >INTO TABLE locations2 > >FIELDS TERMINATED BY '|' > >LINES TERMINATED BY "\r" > > >(@d,@d,LOCNAME,LOCTYPE,@d,STATE,COUNTY,@d,@d,LNG,LAT,@d,@d,@d,@d,@d,@d,@d,@= > >d); > > > >The @d is a dummy variable for information I do not need to import. The > >table structure looks like this: > > > >+---------+-------------+------+-----+---------+----------------+ > >| Field | Type | Null | Key | Default | Extra | > >+---------+-------------+------+-----+---------+----------------+ > >| ID | int(11) | | PRI | NULL | auto_increment | > >| STATE | int(11) | YES | | NULL | | > >| LOCNAME | varchar(25) | YES | | NULL | | > >| LOCTYPE | varchar(10) | YES | | NULL | | > >| COUNTY | int(11) | YES | | NULL | | > >| CTRLAT | float | YES | | NULL | | > >| CTRLNG | float | YES | | NULL | | > >+---------+-------------+------+-----+---------+----------------+ > > > >And here is the error I get: > > > >ERROR 1064 (42000): You have an error in your SQL syntax; check the > manual > >that > >corresponds to your MySQL server version for the right syntax to use near > >'@d,@d > >,LOCNAME,LOCTYPE,@d,STATE,COUNTY,@d,@d,LNG,LAT,@d,@d,@d,@d,@d,@d,@d,@d)' > at > >line > >5 > > > >This error is driving me nuts! Any help would be appreciated, as this is > a > >rather large file. > > > >Jason > > > > > > > >
