How to Excel Export from MySQL

How to excel export a table from MySql.

Here is the command
TableName : EmpData.

Query:
Select * from EmpDate INTO OUTFILE 'empDate.xls';

The exported file will be save on the following path
"C:\ProgramData\MySQL\MySQL Server 5.5\data\<<DatabaseName-Folder>>"

No comments: