How to extract the Table Definitions of a MYSQL Table into CSV?
Solution 1:
Export Table into CSV Format Using MySQL Workbench
-
Run the statement/query and get its result set.
-
Then, in the result panel, click "export recordset to an external file" option. The recordset is used for the result set.
-
Finally, a new dialog box will be displayed. Here, we need to provide a filename and its format.