OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: LOAD DATA INFILE Syntax error

From: Ralph Kutschera (news2008ecuapac.dyndns.org)
Date: Mon Jun 29 2009 - 09:19:21 CDT

Johnny Withers schrieb:
> Group is a keyword in mysql:
>
> You need to put backticks around it in your statement:
>
> | LOAD DATA INFILE 'test.csv' INTO TABLE table
> | FIELDS TERMINATED BY ','
> | LINES STARTING BY '' TERMINATED BY '\n'
> | (Page, Device, `GROUP` , ItemID, Item, Value);

Ooookay. Thank you very much!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql