将MySQL的查询结果保存到文件

将本次查询结果保存到文件

select host,user,password from user into outfile '/home/java/user.xls';

将查询结果都保存到文件

mysql> pager cat >> /home/java/result.txt
mysql> select xxx,xxxxx,xxxx from xx_t;
10135 rows in set (0.57 sec)
mysql> pager;
Default pager wasn't set, using stdout.

使用mysql -e执行

mysql -h localhost -utvzr -p123123 -D mysql -e "select host,user,password from user" > /home/java/result.dat

将SQL保存到文件，进行执行

mysql -h localhost -utvzr -p123123 < t.sql  > /home/java/sql.txt