ssh oracle@172.16.69.128
mysql -u root -p
select * into outfile './test.xls' from TableA;
sudo find / -name "test.xls"
scp /var/lib/mysql/test.xls wjx@172.16.69.1:~
如果本机装有mysql:
echo "use datebase;SELECT * FROM tb1 WHERE 1 ORDER BY id DESC LIMIT 0, 50;" | /usr/bin/mysql -hlocalhost -uroot -pxxxxx > ~/test.xls