mysqldump option to include column names in first row

Question

I'm using mysqldump to dump all my tables to CSV files like so:

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

Is there an option to have mysqldump include the column names in the first row of each file?

This was answered in: http://stackoverflow.com/questions/5467517/mysqldump-create-column-names-for-inserts-when-backing-up — Andymoos, Jan 23 '13 at 17:05
@AndyMornes No, that answer is about a SQL dump, not about CSV export. — depquid, Oct 07 '14 at 16:16

score 6 · Answer 1 · answered Apr 29 '19 at 14:19

6

As of MySQL 5.5 (perhaps before) you can now use --complete-insert or -c to achieve this.

answered Apr 29 '19 at 14:19

Yvan

score 2 · Accepted Answer · answered Dec 15 '10 at 16:30

2

There is not; you'll have to do that yourself.

answered Dec 15 '10 at 16:30

Glen Solsberry

After much googling I was coming to that conclusion. – scumdogg Dec 16 '10 at 01:47

score 1 · Answer 3 · answered Dec 24 '10 at 03:54

1

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

This may not be exact but very close to what you are trying to.

answered Dec 24 '10 at 03:54

shantanuo

3 Answers3