I want to import CSV file into MySQL database but I am getting an error.
This is my method for LOAD DATA INFILE
:
public int Import(string path)
{
try
{
string cmd = "LOAD DATA INFILE " + path + " INTO TABLE zen_hardware.products FIELDS TERMINATED BY ',' LINES TERMINATED BY '
'";
int a = MySqlHelper.ExecuteNonQuery(conn.Connect(),cmd);
return a;
}
catch
{
return -1;
}
}
When I run the code my string cmd gets this:
"LOAD DATA INFILE c:\users\trabajo\documents\visual studio 2013\Projects\Zen Hardware\Presentation\Tarjetas de Video.csv INTO TABLE zen_hardware.products FIELDS TERMINATED BY ',' LINES TERMINATED BY '
'"
And the error I get is this:
You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'c:usersrabajodocumentsvisual studio 2013Projectsen
HardwarePresentation'
I don't know what part of my cmd syntax is wrong.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…