Importing .csv into MySQL table

[Brian Walker]

I have a .csv file with 3 fields (lastname,firstname,phone) and I created a table in MySQL Query Browser 1.2.17 that has the same fields, plus the primary key field set to auto-increment. I get an error when I try to implement the below code that states there is a syntax error, but it isn't specific. Any ideas?

LOAD DATA INFILE 'Test.csv'
INTO TABLE employees
(lastname,firstname,phone)
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
IGNORE 1 LINES;