12

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?

Vnz Dichoso
  • 182
  • 1
  • 2
  • 11

1 Answers1

18

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.

Ariful Islam
  • 7,639
  • 7
  • 36
  • 54
  • 1
    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? – Dhruv Dec 18 '18 at 06:38
  • 2
    @dhroove Sorry for late response. Just select "Don't Limit" from the tool bar of Workbench. – Ariful Islam Dec 23 '18 at 08:22
  • 1
    @ArifulIslam: yup.. was able to figure out that day. But many thanks for the reply. – Dhruv Dec 26 '18 at 05:21