title: How to export table with its attribute names?
body: <p>I am trying to  output query result into a csv file</p>
  <pre><code>select*from  fileName INTO OUTFILE 'C:\\Users\\UserName\\Desktop\\ans.csv' 
  columns terminated by ',' lines terminated by ',\n' ;
  </code></pre>
  <p>It is working fine but it is exporting the data I want to export data with attribute names.How to do that.</p>
  <p><code>Example of EXPECTED OUTPUT</code> I want data to be exported along with ID NAME AND CLASS.</p>
  <pre><code> 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
  </code></pre>