Re: Exporting to CSV with Headers

[Peter Brawley]

> There doesn't seem to be one that does not manually enumerate all the columns.

To avoid having to do it manually, you could generate it from information_schema ...

select group_concat( column_name order by ordinal_position separator ' ')
from information_schema.columns
where table_schema='db' and table_name='tbl'
union
...



Edited 1 time(s). Last edit at 05/24/2018 07:21AM by Peter Brawley.