blocks|key|524235|text|我猜你遗漏了所附的BY条款。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|524236|LOAD+DATA+LOCAL+INFILE+'/path/to/your/csv/file/model.csv'
INTO+TABLE+test.dummy+FIELDS+TERMINATED+BY+','
ENCLOSED+BY+'"'+LINES+TERMINATED+BY+'\n';|code-block|syntax|javascript|524237|并指定csv文件的完整路径|524238|Load+Data+Infile+-+MySQL+documentation|offset|length|524239|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.1/en/load-data.html^0|0|0|0|0|12|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|X|8|@]|9|@$K|Y|L|Z|1|10]]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

I guess you're missing the ENCLOSED BY clause

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

And specify the csv file full path

<a href="http://dev.mysql.com/doc/refman/5.1/en/load-data.html" rel="noreferrer">Load Data Infile - MySQL documentation</a>

blocks|key|307702|text|在模式下的导航器中，右键单击您的模式/数据库，然后选择“表数据导入向导”|type|unstyled|depth|inlineStyleRanges|entityRanges|data|307703|也适用于mac。|307704|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

In the navigator under SCHEMAS, right click your schema/database and select "Table Data Import Wizard"

Works for mac too.

blocks|key|524497|text|您可以使用MySQL+Table+Data+Import+Wizard|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|524498|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-table.html^0|B|O|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

You can use MySQL <a href="https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-table.html" rel="nofollow noreferrer">Table Data Import Wizard</a>

blocks|key|307654|text|目前，不可能在所有平台上导入CSV+(使用MySQL工作台)，如果所述文件不在与MySQL服务器主机相同的主机中，也不建议这样做。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|307655|但是，您可以使用mysqlimport。|offset|length|307656|示例：|307657|mysqlimport+--local+--compress+--user=username+--password+--host=hostname+\
--fields-terminated-by=','+Acme+sales.part_*|code-block|syntax|javascript|307658|在本例中，mysqlimport被指示加载所有名为"sales“、扩展名以"part_”开头的文件。这是加载"split“示例中创建的所有文件的便捷方法。使用--compress选项最小化网络流量。--fields+terminated-by=‘，’选项用于CSV文件，--local选项指定传入数据位于客户端。如果不使用--local选项，MySQL将在数据库主机上查找数据，因此请始终指定--local选项。|style|CODE|307659|在AWS+RDS+documentation中有关于这个主题的有用信息。|307660|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.6/en/mysqlimport.html|1|http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.AnySource.html^0|0|8|B|0|0|0|0|5|B|0|1|L|1|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|13|8|@]|9|@$D|14|E|15|1|16]]|A|$]]|$1|F|3|G|5|6|7|17|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|18|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|19|8|@$D|1A|E|1B|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1C|8|@]|9|@$D|1D|E|1E|1|1F]]|A|$]]|$1|S|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]|10|$5|V|W|X|A|$Y|11]]]]

At the moment it is not possible to import a CSV (using MySQL Workbench) in all platforms, nor is advised if said file does not reside in the same host as the MySQL server host.

However, you can use <a href="http://dev.mysql.com/doc/refman/5.6/en/mysqlimport.html" rel="nofollow">mysqlimport</a>.

Example:

<pre><code>mysqlimport --local --compress --user=username --password --host=hostname \
--fields-terminated-by=',' Acme sales.part_*
</code></pre>

In this example <code>mysqlimport</code> is instructed to load all of the files named "sales" with an extension starting with "part_". This is a convenient way to load all of the files created in the "split" example. Use the --compress option to minimize network traffic. The --fields-terminated-by=',' option is used for CSV files and the --local option specifies that the incoming data is located on the client. Without the --local option, MySQL will look for the data on the database host, so always specify the --local option.

There is useful information on the subject in <a href="http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.AnySource.html" rel="nofollow">AWS RDS documentation</a>.

blocks|key|307511|text|如果服务器驻留在远程计算机上，请确保文件位于远程计算机中，而不是本地计算机中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|307512|如果该文件与mysql服务器在同一台计算机上，请确保mysql用户有权读/写该文件，或者将该文件复制到mysql模式目录中：|307513|在我使用ubuntu的例子中，它是:+/var/lib/mysql/db_myschema/myfile.csv|307514|此外，与此问题无关，但如果您在使用新行时遇到问题，请使用sublimeTEXT将行尾更改为WINDOWS格式，保存文件，然后重试。|307515|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

If the server resides on a remote machine, make sure the file in in the remote machine and not in your local machine. 

If the file is in the same machine where the mysql server is, make sure the mysql user has permissions to read/write the file, or copy teh file into the mysql schema directory:

In my case in ubuntu it was: /var/lib/mysql/db_myschema/myfile.csv

Also, not relative to this problem, but if you have problems with the new lines, use sublimeTEXT to change the line endings to WINDOWS format, save the file and retry.

blocks|key|524347|text|这看起来有点棘手，因为它真的困扰了我很长一段时间。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|524348|你只需要打开表格(右击“选择行-限制10000")，你就会打开一个新的窗口。在这个新窗口中，你会发现“导入图标”。|524349|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

It seems a little tricky since it really had bothered me for a long time.

You just need to open the table (right click the "Select Rows- Limit 10000") and you will open a new window. In this new window, you will find "import icon".

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. 

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

<pre><code>"Service Area Code","Phone Numbers","Preferences","Opstype","Phone Type"
</code></pre>

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

<pre><code>ServiceAreaCodes,PhoneNumbers,Preferences,Opstyp,PhoneTyp. 
</code></pre>

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

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

but I am getting an error like <code>model.CSV file not found</code>

How to import a csv file into MySQL workbench?

数据库

服务器

MySQL

我有一个CSV文件。它包含140万行数据，因此我无法在Excel中打开csv文件，因为它限制在100万行左右。因此，我希望在MySQL工作台中导入此文件。此csv文件包含如下列"Service Area Code","Phone Numbers","Preferences","Opstype","Phone Type"我正尝试在MySQL工作台中创建一个名为"dummy“的表，其中包含如下列Ser

问如何将csv文件导入MySQL工作台？
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将csv文件导入MySQL工作台？EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将csv文件导入MySQL工作台？
EN