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>>"
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:
Post a Comment