export table in mysql using query code example
Example 1: how to export table data from mysql table in sql format
SELECT * FROM tbl_order INTO OUTFILE 'file save path/filename'
Example 2: export mysql table to file
mysqldump db_name tbl_name;
SELECT * FROM tbl_order INTO OUTFILE 'file save path/filename'
mysqldump db_name tbl_name;