[TriLUG] mysql problem
Glenn Hennessee
glenn.hennessee at gmail.com
Fri Feb 8 16:54:20 EST 2008
I'm having a problem with mysql. I need to upload data that contains '
and " characters from an excel spreadsheet. What I have done is create
text strings that look like
:|76189-56-5|,|(S)-(-)-2,2'-bis(diphenylphosphino)-1,1'-binaphthyl|
and then I'm using this command
load data infile '/home/setup/gunnoe.sql' into table chemical fields
delimited by '|' terminated by ',' lines starting by ':'
but I get an error of
|#1064 - 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 'delimited by '|' terminated by ',' lines starting by ':'' at line 1
I get the error whenever I have any of the delimited by, terminated by,
etc. phrases. I would also like to change the table to be table
(cas,name) since there are other fields that aren't being uploaded here.
When I add the (cas,name) and leave off the rest of the line it puts as
much of the whole line as fits into the cas element but does no parsing.
I picked this method up from
http://russell.dyerhouse.com/cgi-bin/article.cgi?article_id=31 and have
consulted the mysql documentation at
http://dev.mysql.com/doc/refman/5.0/en/load-data.html which confirms the
article at russell.dyerhouse.com. Mysql gives
Server version: 5.0.45-Debian_1ubuntu3.1-log Debian etch distribution
on startup. I'm out of ideas on this, does anyone have any?
Thanks for any ideas.
glenn
More information about the TriLUG
mailing list