将本次查询结果保存到文件
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