MySQL Forums
Forum List  »  MySQL for Excel

Re: Insert Data in Table from CSV File - Error 1064
Posted by: Andrew Lietzow
Date: January 01, 2013 10:02AM

I've stared at this quite a bit and can't find any errors.

LOAD DATA LOCAL INFILE `C:/Users/AndrewL/Desktop/IA_Senate_Members.csv` into table `ia senate members` FIELDS TERMINATED BY ',' FIELDS ENCLOSED BY ',' LINES TERMINATED BY '\n\r' (SD-ID, Last_Name, First_Name, SD, Senator_Full_Name, Party Affiliation, County, eMail Address, MI, Address1, Address2, City, ST, ZIP, Primary_Phone); show warnings

How do I check to make sure "enable --Local-Infile" is set to yes? My Workbench version is 5.2.44 and I'm using MySQL Server 5.5.

Options: ReplyQuote


Subject
Views
Written By
Posted
2200
October 29, 2012 11:30AM
1800
December 04, 2012 07:50AM
Re: Insert Data in Table from CSV File - Error 1064
1387
January 01, 2013 10:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.