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
Vnz Dichoso
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
Ariful islam
source
to share