Clever Geek Handbook

Mysql Workbench, export selected table rows

I already know how to export the entire database, but how do you export the selected rows?

Let's say I need to export data from these queries: select * for users where gender = "0"; How do you turn them into a dump file?

+3


source to share


1 answer


A simple way to do it:

Complete your request. In your caseselect * from users where gender="0";



In the results section, you will find an option File:

. There you will get Export record set to an external file

. Click here and save the file in the desired extension.

That's all.

+8


source






More articles:


All Articles