Mysqldump option to include column names in the first row

Question

I use mysqldump to output all my tables to CSV files as follows:

mysqldump -u -p -t -TC: \ Temp --fields-terminated-by =,

Can mysqldump include column names in the first line of each file?

Answer 1

No; you have to do it yourself.

Answer 2

mysql test -e"select * from users" | tr '\t' ',' > tocsv.csv

This may not be entirely accurate, but very close to what you are trying to do.

Answer 3

MySQL 5.5 (, ), --complete-insert -c .