MySQL dump specific columns

I thought that I had to dump specific columns from a table. In the end I needed to parse the resulting XML with a script anyway to convert it to CSV, but here is a reminder for myself (and maybe you):

Raw
mysql -u <user> -p <database> --execute="SELECT * FROM sometable" -X > out.xml

0 comments

Start a new thread

Cancel reply