将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
命令轻松完成此操作。
示例:
p>
LOAD DATA LOCAL INFILE'/data.csv'INTO TABLE my_table FIELDS TERMINATED BY','
您应该可以从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屋!