[ACCEPTED]-Export SQL table in CSV With Headers-phpmyadmin

Accepted answer
Score: 17

This works for me. What version of phpmyadmin 1 do you have?

  1. Under Browse, click on the table you want to export.
  2. At the bottom, in the Query results operations section, click on Export.
  3. In Export method, choose Custom.
  4. Change Format to CSV for MS Excel.
  5. Under Format-specific options, check Put columns names in the first row.
Score: 1
  1. Click on the export button
  2. Export method custom
  3. Format CSV
  4. Format-specific options: Put columns names in the first row ( Select this checkbox)

enter image description here


More Related questions