将CSV文件加载到MySQL Workbench [英] Loading CSV files into MySQL Workbench

问题描述

我有很多excel / CSV文件，我需要加载到我的数据库在MySQL Workbench（我在Mac OS X）。我已经搜索了一个很好的步行或教程，但我没有看到任何明确解释如何加载CSV到MySQL Workbench ....任何人都可以帮助吗？

解决方案

是否正在将csv文件加载到MySQL表中？您可以使用 LOAD DATA LOCAL INFILE 命令轻松完成此操作。

示例：


LOAD DATA LOCAL INFILE'/data.csv'INTO TABLE my_table FIELDS TERMINATED BY'，'
p>

您应该可以从MySQL的任何接口输入该命令。我假设工作台有一个方法来执行sql查询。

I have a lot of excel/ CSV files that I need to load into my db in MySQL Workbench (I'm on Mac OS X). I've searched around for a good walk-through or tutorial, but I haven't seen anything that clearly explains how to load CSVs into MySQL Workbench....can anyone help?

解决方案

are you trying to load csv files into a MySQL table? You can do that easily with the LOAD DATA LOCAL INFILE command.

Example:

LOAD DATA LOCAL INFILE '/data.csv' INTO TABLE my_table FIELDS TERMINATED BY ','

You should be able to enter that command from any interface to MySQL. I'm assuming workbench has a way for you to execute sql queries.

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