将mysql中数据导出到execel表

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