[ILUG] MySQL and LOAD DATA

[Rory Winston]

Hi

I am using MySQL 3.23.47 and am trying to load a .CSV file with employee
details into it. The exact command I am using is:

LOAD DATA INFILE "foo.csv" 
INTO TABLE attendees (forename, surname, job_title, division) 
FIELDS TERMINATED BY ','

However, I get ERROR 1064: You have an error in your SQL syntax near 'FIELDS
TERMINATED BY ','.
If I leave out the FIELDS TERMINATED BY clause it will load the data, but
since it doesnt recognize the comma delimiter, I get all the data in one
column!! Arrgh!!

Does anyone have any ideas what I am doing wrong here?

Cheers 

Rory 

--------------------------------------------
Rory Winston,
Developer,
Oneline Team,
Telewest Broadband,
Export House,
Woking,
Surrey
GU21 5RW

mailto: rory.winston at telewest.co.uk
phone:  01483 582474
mobile: 07909 538238

------------------------------------------------------------------------------
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer.


==============================================================================