List:General Discussion« Previous MessageNext Message »
From:Jason Ferguson Date:September 27 2005 1:41am
Subject:Re: LOAD DATA INFILE Syntax Error
View as plain text  
Okay, now I get it. I was using the 4.1 series. Looks like an upgrade is in
order.

Jason

On 9/26/05, Jasper Bryant-Greene <jasper@stripped> wrote:
>
> Robert L Cochran wrote:
> > http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html
>
> There's a lot to read there for one small paragraph, so from the above
> link:
>
> "Before MySQL 5.0.3, the column list must contain only names of columns
> in the table being loaded, and the SET clause is not supported. As of
> MySQL 5.0.3, the column list can contain either column names or user
> 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 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
> >>
> >>
> >>
> >
> >
>
> --
> 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/mysql?unsub=1
>
>

Thread
LOAD DATA INFILE Syntax ErrorJason Ferguson27 Sep
  • Re: LOAD DATA INFILE Syntax ErrorRobert L Cochran27 Sep
    • Re: LOAD DATA INFILE Syntax ErrorJasper Bryant-Greene27 Sep
      • Re: LOAD DATA INFILE Syntax ErrorJason Ferguson27 Sep
    • Re: LOAD DATA INFILE Syntax ErrorJason Ferguson27 Sep