Mysql Workbench, exporting selected rows of a table

mysql export dump workbench
Vnz Dichoso picture Vnz Dichoso · Nov 3, 2014 · Viewed 7.1k times · Source

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

Ariful Islam picture Ariful Islam · Nov 3, 2014

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.

Related questions

Export MySQL data to Excel in PHP

I'm trying to get my MySQL data to Excel file, but I'm having problems with Excel cells. All my text goes to one cell, I would like to have each row value in separate Excel cell. Here is my code: $…

Read More
Exporting results of a Mysql query to excel?

My requirement is to store the entire results of the query SELECT * FROM document WHERE documentid IN (SELECT * FROM TaskResult WHERE taskResult = 2429) to an Excel file.

Read More
mysqlworkbench giving version error on exporting database

When I try to export my database through MySQL Workbench remotely from localserver, I am getting some below version error: mysqldump Version Mismatch [Content] mysqldump.exe is version 5.5.16, but the MySQL Server to be dumped has version 5.6.10-log. Because the …

Read More