CODEWITHSUNDEEP
mysqlcsvmysql-workbenchexport-to-csv
NullReference
NullReference

Reputation: 2968

How to: Export a recordset as a semicolon separated csv file in MySQL workbench?

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?

Upvotes: 3

Views: 11413

Answers (2)

Philip Olson
Philip Olson

Reputation: 4850

Yes, you can. When you are exporting the result set, choose "CSV (; separated)" instead of "CSV" as the output format. See the related documentation (and a screenshot).

Alternatively, the table "Table Data Export Wizard" also has an option to use ";" as the field separator. Get there by right-clicking on a table in the schema viewer.

Upvotes: 3

Priyambada Madala
Priyambada Madala

Reputation: 186

1.run the query for output in Workbench

2.select the following button for export to records enter image description here

  1. Insert the following values

enter image description here

  1. Click on export. The records would be exported to a csv file mentioned in the "File Path"

Upvotes: 1

Related Questions