如何将csv文件导入MySQL工作台？ [英] How to import a csv file into MySQL workbench?

问题描述

我有一个CSV文件。它包含140万行数据，因此我无法在Excel中打开该csv文件，因为它的限制是大约1百万行。

I have a CSV file. It contain 1.4 million rows of data, so I am not able to open that csv file in Excel because its limit is about 1 million rows.

因此，我想在MySQL Workbench中导入此文件。此csv文件包含

Therefore, I want to import this file in MySQL workbench. This csv file contains columns like

"Service Area Code","Phone Numbers","Preferences","Opstype","Phone Type"

我试图在MySQL工作台中创建一个名为dummy的表，

I am trying to create a table in MySQL workbench named as "dummy" containing columns like

ServiceAreaCodes,PhoneNumbers,Preferences,Opstyp,PhoneTyp. 

CSV文件名为 model.csv 。我的工作台代码是这样的：

The CSV file is named model.csv. My code in workbench is like this:

LOAD DATA LOCAL INFILE 'model.csv' INTO TABLE test.dummy FIELDS TERMINATED BY ',' lines terminated by '\n';

但我得到一个错误，例如 model.CSV file not found

but I am getting an error like model.CSV file not found

推荐答案

我想你缺少ENCLOSED BY子句

I guess you're missing the ENCLOSED BY clause

LOAD DATA LOCAL INFILE '/path/to/your/csv/file/model.csv' INTO TABLE test.dummy FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

并指定csv文件完整路径

And specify the csv file full path

载入数据Infile - MySQL文档

这篇关于如何将csv文件导入MySQL工作台？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！