List:General Discussion« Previous MessageNext Message »
From:Ralph Kutschera Date:June 29 2009 2:19pm
Subject: Re: LOAD DATA INFILE Syntax error
View as plain text  
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!

Thread
LOAD DATA INFILE Syntax errorRalph Kutschera29 Jun
  • Re: LOAD DATA INFILE Syntax errorJohnny Withers29 Jun
    • Re: LOAD DATA INFILE Syntax errorRalph Kutschera29 Jun