1.使用MySQL命令

SELECT columns FROM table_name WHERE whatever='something' INTO OUTFILE "/tmp/outfile.txt";
 

2.命令行方式

2.1.管道方式

echo "SELECT columns FROM table_name WHERE whatever='something'" | /path/to/mysql -uUSERNAME -pPASSWORD DATABASENAME > /tmp/outfile.txt;
 

2.2.使用SQL文件

/path/to/mysql -uUSERNAME -pPASSWORD DATABASENAME < /tmp/sql.sql > /tmp/outfile.txt;