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?

Phony

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.

Affined

what this option is only exporting 1000 records i.e. the limit of select. But i have around 5 lakhs record to export. How to do the same? – Wnw

@dhroove Sorry for late response. Just select "Don't Limit" from the tool bar of Workbench. – Affined

@ArifulIslam: yup.. was able to figure out that day. But many thanks for the reply. – Wnw