mysql export data tables and procedures code example

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

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