particular-column-mysql

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!

 

About the Author

agurchand

Software Engineer, Blogger etc., Visit my Youtube channel - <a href="http://www.youtube.com/agurchand">Click Here</a>

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

Leave a Reply

Your email address will not be published. Required fields are marked *