How to export table with its attribute names?

Question

I am trying to output query result into a csv file

select*from  fileName INTO OUTFILE 'C:\\Users\\UserName\\Desktop\\ans.csv' 
columns terminated by ',' lines terminated by ',\n' ;

It is working fine but it is exporting the data I want to export data with attribute names.How to do that.

Example of EXPECTED OUTPUT I want data to be exported along with ID NAME AND CLASS.

 ID   NAME   CLASS
 1    AB     d3
 2    cc     d4
 3    ff     g8

What I am getting!1 
 1    AB     d3
 2    cc     d4
 3    ff     g8

https://stackoverflow.com/questions/5941809/include-headers-when-using-select-into-outfile — Mehdi, Jun 30 '20 at 10:00
See, particularly, [this answer](https://stackoverflow.com/a/13603727/5790584). — Eric Brandt, Jun 30 '20 at 10:48

score 0 · Accepted Answer · answered Jun 30 '20 at 10:03

0

Try this :

SELECT 'Name',
       'CLASS'
UNION ALL
SELECT Name,
       CLASS
FROM fileName INTO OUTFILE 'C:\\Users\\UserName\\Desktop\\ans.csv' columns terminated BY ',
                                                                                        ' lines terminated BY ',\n'

answered Jun 30 '20 at 10:03

Arsalan Valoojerdi

961
6
16

We have to hard code it? – Nurav Jun 30 '20 at 10:06
Yes I think . I don't know any other way. – Arsalan Valoojerdi Jun 30 '20 at 10:15
Why don't you use SQL Server Import and Export Wizard instead of query ? – Arsalan Valoojerdi Jun 30 '20 at 10:16
I don't want to do this manually again and again !! – Nurav Jun 30 '20 at 10:19
@Arsalan Valoojerdi - OP is not using sqlserver – P.Salmon Jun 30 '20 at 10:25

How to export table with its attribute names?

1 Answers1