export table to excel mysql code example

Example: how to export table data from mysql table in sql format

SELECT * FROM tbl_order INTO OUTFILE 'file save path/filename'