如何：在MySQL工作台中将记录集导出为分号分隔的csv文件？(How to: Export a recordset as a semicolon separated csv file in MySQL workbench?)

mysql

 将记录集导出到外部csv文件会生成一个csv文件，该文件在Mysql工作台中以逗号分隔。 有没有办法让它导出到分号分隔的csv文件？  
 我试着看看Mysql workbench中是否有一些设置可以改为使csv以分号分隔但无法找到。 导出的csv文件是否以逗号分隔，并且无法更改或是否有解决方法？ 

Exporting a recordset to an external csv file generates a csv file which is comma separated in Mysql workbench. Is there a way to make it export to a semicolon separated csv file instead?. 
I tried looking if there is some settings in Mysql workbench which can be changed to make the csv as semicolon separated but couldnt find. Is the exported csv file comma separated by default and cannot be changed or is there a workaround?

原文：https://stackoverflow.com/questions/32712082

更新时间：2022-03-22 08:03

最满意答案

 1.运行Workbench中的输出查询  
 2.选择以下按钮以导出到记录   
 
  插入以下值  
 
   
 
  点击导出。 记录将导出到“文件路径”中提到的csv文件  

1.run the query for output in Workbench 
2.select the following button for export to records  
 
 Insert the following values  
 
 
 
 Click on export. The records would be exported to a csv file mentioned in the "File Path"