Mysql Workbench, exporting selected rows of a table

Question

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

Say I need to export data from this queries: select * from users where gender="0"; How do you do turn them into a dump file?

Answer 1

Easy way to do that:

Execute your query. In your case select * from users where gender="0";

In result section you will find File: option. There you will get Export record set to an external file. Click here and save your file in your desired extension.

Thats all.