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):
mysql -u <user> -p <database> --execute="SELECT * FROM sometable" -X > out.xml
0 comments
Reply