Use Parts > Tools > Export for MySQL
Or tables can be exported using MySQL Workbench.
Right Click on a table and select the Table Data Export Wizard.
Recommended Options for Parts:
Set File Path and file name to a location on the local machine.
Select csv
Line Separator: LF (linefeed)
Enclose Strings in: " (double quote)
Field Separator: | (pipe)
Null: Yes
Check export to local machine.
Select Next > Next > Finish
Related Links: Export to Excel
That's it !
No comments:
Post a Comment