How to export specific columns in mysql?


This was the question asked by many programmers lately to me!. That’s why I’m writing this post now!

It’s not hard as you think if you’re using PhpMyAdmin by the way I don’t have hope in SQLBuddy 🙂


1. First open your table that you want to export.

2. Just SQL Query it in PhpMyAdmin. For Example, See the below table “asset”.


Just Query the 4 columns:

“select agencyid, model, serialno, employee from asset”.

After you query you will get this page:


If you scroll the page to the bottom of the result you can see this icon with Export Option:


Just click the Export Icon in the bottom of the table that’s it.


Just Select SQL and Press go to download Specific Columns from at Table. Easy!


One thought on “How to export specific columns in mysql?

Leave a Reply

Theme: Overlay by Kaira