Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to export a single table from phpmyadmin to a comma delimited text file?

I need to export a table from phpmyadmin to a comma delimited text file. I think there is a code but can't seem to find it. I found one but it doesnt work.

I need to export this table because I need to organize it and sort it and add another column so I can add data to this column.

How can I do this please?

like image 745
seedg Avatar asked Dec 02 '22 06:12

seedg


1 Answers

In PHPAdmin, if I recall correctly, there is an Export tab. If you click on that, you can select the table(s) you want to export and which format you would like to export the data in. CSV, .zip, .gzip, etc...

like image 82
jaywon Avatar answered Dec 05 '22 00:12

jaywon