export mysql table to csv file using batch script

Question

I am trying to export mysql table data to csv file using batch file. It works on the screen but not able to ouptut to a csv file.

 @echo off
    " C:\ProgramFiles\MYSQL\MYSQL Workbench 6.3 CE\mysql.exe" mysql -uroot -ppassword -e "select plate form SWP;" > \output.csv
    pause
    exit

\output.csvwierd path looks to me as a invalid windows path. Use more something like C:/output.cvs — Raymond Nijland
– Raymond Nijland, Commented Jul 9, 2018 at 14:59
@RaymondNijland, the "weird" path \output.csv points to the file output.csv in the current drive; it is valid, but might be unintended; using C:/output.csv is not recommended (though it might work) as the Windows path separator is \ ... — aschipfl
– aschipfl, Commented Jul 9, 2018 at 15:06
Since the problem seems to be caused by a simple typo, this question should be deleted in my opinion, because it is not going to help other users... — aschipfl
– aschipfl, Commented Jul 9, 2018 at 15:07
@RaymondNijland, to explicitly point to the current working directory, you would need to specify .\output.csv, which is equivalent to output.csv... — aschipfl
– aschipfl, Commented Jul 9, 2018 at 15:18

Paul Martelin · Accepted Answer · 2018-07-09 15:51:24Z

1

mysql got a feature for this : LOAD DATA INFILE This will load the content of a query in a file.

Check the doc here :

https://dev.mysql.com/doc/refman/5.7/en/load-data.html

answered Jul 9, 2018 at 15:51

Paul Martelin

215 bronze badges

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

Collectives™ on Stack Overflow

export mysql table to csv file using batch script

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