mysql export data using query code example

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

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