Question: how to export data from mysql server to excel using query?
Answer: Start Excel, select the Data menu tab, and then click MySQL for Excel to open the MySQL for Excel task pane.
From the Open a MySQL Connection area in the task pane, double-click an existing local or remote connection to display the available database schemas.