mysql table export sql command line code example

Example 1: mysql export database command line

mysqldump -uroot -p root YourDatabaseName > WantedSQLFile.sql

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

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