Question: how to export data from mysql table?
Answer: First, execute a query get its result set.
Second, from the result panel, click “export recordset to an external file”. The result set is also known as a recordset.
Third, a new dialog displays. It asks you for a filename and file format.