title: phpmyadmin exporting to csv for excel
body: <p>I'm having problem using xampp (4.1.6) phpmyadmin export function. When I export, I select csv for excel format, but it will return the data like:</p>
  
  <pre><code>1;"data1";"0";"6828";"2014-03-13 13:54:26";"2014-03-13 13:54:26";"file";;"2014-03-14 14:45:51"
  </code></pre>
  
  <p>So I tried the syntax:</p>
  
  <pre><code>SELECT * FROM `directory_listing` 
  INTO OUTFILE 'C:/test.csv' 
  FIELDS TERMINATED BY ',' 
  ENCLOSED BY '"' 
  LINES TERMINATED BY '\n'
  </code></pre>
  
  <p>Now the format is the same as the table view as in mysql table. Problem is, I want to display the column name on 1st row. How can i do that?</p>
  
  <p>By the way, below is the interface of my phpmyadmin export function. </p>
  
  <p><img src="https://i.stack.imgur.com/93oIM.jpg" alt="phpmyadmin export tab"></p>
  
  <p>I tried to export it as normal csv, but it still return the same. even worse, ALL the data is put inside 1st row.</p>
  
  <p><img src="https://i.stack.imgur.com/mnmSU.png" alt="phpmyadmin export for normal csv"></p>