MySQL Forums
Forum List  »  CSV Storage Engine

Unable to import csv by sqlimport
Posted by: Alan Jebakumar
Date: October 19, 2015 01:45PM

Hey Team,

Im trying to import the below csv file data-
Names
Gould, Cherokee
Mccall, Quyn
Blair, Jerome
Norris, Austin
Bush, Vera
Bryant, Macy
Bray, Raphael
Kelley, Drake
Moore, Yardley
Compton, Pascale
Howell, Martena

But i get the below error during its mysqlimport operation-
C:\Program Files\MySQL\MySQL Server 5.6\bin>.\mysqlimport.exe Events h:\Desktop\Nameslist.csv -u root -h dcw01 -vr --local -p --fields-enclo
sed-by='"'
Enter password: ********
Connecting to dcw01
Selecting database Events
Loading data from LOCAL file: h:/Desktop/Nameslist.csv into Nameslist
.\mysqlimport.exe: Error: 1083, Field separator argument is not what is expected; check the manual, when using table: Nameslist

Do suggest how this can be fixed.

Cheers, Alan.

Options: ReplyQuote


Subject
Views
Written By
Posted
Unable to import csv by sqlimport
2335
October 19, 2015 01:45PM


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.