MySQL加载数据文件 [英] MySQL Load Data Infile

问题描述

我想将CSV文件导入MySQL数据库，但是出现错误.

I want to import CSV file into MySQL database but I am getting an error.

这是我用于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 '\n'";

      int a = MySqlHelper.ExecuteNonQuery(conn.Connect(),cmd);

      return a;
   }
   catch
   {
      return -1;
   }
}

当我运行代码时，我的字符串cmd会得到以下信息:

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 '\n'"

我得到的错误是:

您的SQL语法有错误；检查手册 对应于您的MySQL服务器版本以使用正确的语法 'c:\ users \ trabajo \ documents \ visual studio 2013 \ Projects \ Zen附近 硬件\演示'

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:\users\trabajo\documents\visual studio 2013\Projects\Zen Hardware\Presentation'

我不知道我的cmd语法的哪一部分是错误的.

I don't know what part of my cmd syntax is wrong.

推荐答案

在使用具有空格的地址时，必须在地址前后使用单引号('):

when you are using an address that have space, must use single quotation (') before and after address like this:

"LOAD DATA INFILE'c:\ users \ trabajo \ documents \ visual studio 2013 \ Projects \ Zen硬件\ Presentation \ Tarjetas de Video.csv'插入表zen_hardware.products字段以'，'终止于'\ n'"

"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 '\n'"

public int Import(string path)
{
   try
   {
      string cmd = "LOAD DATA INFILE '" + path + "' INTO TABLE zen_hardware.products FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'";
      int a = MySqlHelper.ExecuteNonQuery(conn.Connect(),cmd);
      return a;
   }
   catch
   {
      return -1;
   }
}

请参阅MySQL手册页，标题为 LOAD DATA INFILE语法.

Please see the MySQL Manual Page entitled LOAD DATA INFILE Syntax.

这篇关于MySQL加载数据文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！