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/[EMAIL PROTECTED]
