[TriLUG] mysql problem
mattnash at intrex.net
Fri Feb 8 17:11:00 EST 2008
From my reading of the Mysql SQL syntax reference, you want to say
"fields terminated by '|' " and not "delimited by".
Glenn Hennessee wrote:
> 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
> 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.
More information about the TriLUG