javascript python java c# php android html jquery c++ css ios mysql sql r node.js arrays reactjs c asp.net json ruby-on-rails .net sql-server swift python-3.x objective-c django angular angularjs excel regex pandas ruby iphone ajax linux xml vba asp.net-mvc spring laravel database wordpress typescript string wpf mongodb windows xcode postgresql bash oracle git vb.net amazon-web-services multithreading list firebase flutter eclipse spring-boot dataframe azure react-native algorithm docker macos forms image visual-studio scala powershell function twitter-bootstrap numpy api performance selenium winforms python-2.7 matlab vue.js sqlite apache hibernate entity-framework loops rest shell facebook express android-studio csv linq maven qt swing unit-testing file tensorflow

[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

0

Source: stackoverflow.com

More Related questions

Import large csv file using phpMyAdmin

PHPMyAdmin doesn't connect after root password change

To get MYSQL query execution time in Query

phpmysql error - #1273 - #1273 - Unknown collation: 'utf8mb4_general_ci'

wamp cannot load mysqli extension

#1025 - Error on rename of './database/#sql-2e0f_1254ba7' to './database/table' (errno: 150)

Update records with random number

How to drop all table in MySQL?

phpmyadmin opens MySQL table lists very slowly

phpMyAdmin permissions for config.inc.php