Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to export Table to CSV along with column names in PHPMYADMIN

Tags:

php

mysql

phpmyadmin

export-to-csv

I am trying to export the users table into CSV format using PHPMYADMIN but i get only the records and not the coloumn names. So How to do that? I am trying to import a CSV but it needs coloumn names so i want to have a csv that has column names !

like image 387
Rajan Avatar asked Sep 18 '15 07:09

Rajan

1 Answers

where you download table into csv

just click on "put column name in the first row. check below image

enter image description here

like image 175
Maksud Mansuri Avatar answered Nov 09 '22 02:11

Maksud Mansuri
Sign in to Comment

Related questions

Insert data through ajax into mysql database
Inserting MySQL results from PHP into JavaScript Array
how to delete files from remote server using phpStorm
laravel regex validation not working
PHP 5.3.10 vs PHP 5.5.3 syntax error unexpected '['
PHPStorm change color for diff gutter and collapse arrows in editor
unable to load google api php client library in codeigniter
Import class conditionally with the keyword 'use'
WooCommerce - How to create multiple single product template based on category?
Caching Doctrine results Symfony2
What is an array internal pointer in PHP?
How do I send parameters for a PUT request in Guzzle 5?
In Laravel, what validation rules do I need to check the number of characters in a number?
Nginx: Override host header when using fastcgi_pass
Yii2 How to add parameters to script tag
Laravel 5 Migration, Invalid default value when integer
Prestashop redirects to old domain after changing it in Database
cakephp 3.0 how to populate a select field with values instead of id
Difference between setting ID directly and setting eloquent associate relation when saving a model in Laravel?
Telegram BotApi, Send message to multiple chat_id

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!