如何将MySql Workbench中的表数据导出到csv? [英] How to export table data in MySql Workbench to csv?

问题描述

我想知道如何将表数据导出到csv中?我读到我需要使用mysql workbench命令行，但是我不知道如何启动cmd行(不知道命令是什么).

I am wondering how do I export table data into a csv? I read that I need to use mysql workbench command line but I can not figure out how to launch the cmd line(don't know what the command is).

在Windows 7 64bit上运行.

Running on Windows 7 64bit.

推荐答案

您可以在MySQL Workbench SQL编辑器中从要导出的表中选择行.您将在结果集中找到一个导出"按钮，该按钮可让您将记录导出到CSV文件，如下图所示:

You can select the rows from the table you want to export in the MySQL Workbench SQL Editor. You will find an Export button in the resultset that will allow you to export the records to a CSV file, as shown in the following image:

还请记住，默认情况下，MySQL Workbench将结果集的大小限制为1000条记录.您可以在首选项"对话框中轻松更改它:

Please also keep in mind that by default MySQL Workbench limits the size of the resultset to 1000 records. You can easily change that in the Preferences dialog:

希望这会有所帮助.

这篇关于如何将MySql Workbench中的表数据导出到csv?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！