How to output MySQL query results in csv format in Windows environment?

Question

Is there an easy way to run a MySQL query from the PowerShell command line and output the results into a csv formatted file?

This question is the same as How to output MySQL query results in CSV format? except in Windows. I had to figure it out in PowerShell but my answer didn't belong on the linux question. So here's the Windows+PowerShell sibling.

Community · Accepted Answer · 2017-05-23 12:22:27Z

2

Stan's answer from How to output MySQL query results in CSV format?, adapted for Windows PowerShell

mysql my_database_name -u root | Out-File .\my_output_file.csv

This gives me a mysql prompt, but without the usual mysql > at the start. I type:

source C:\Aboslute\Path\With Spac es\Without\Quotes\To\my_select_statement.sql

It gives an error message and exits if there is a problem with the command, or gives me the empty prompt if the command executed successfully. I type exit to finish up.

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered Sep 30, 2015 at 2:33

alexanderbird

4,2561 gold badge30 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to output MySQL query results in csv format in Windows environment?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related