Mysql命令结果重定向相关

来自三线的随记

one

select * from table limit 100  into outfile '/home/test.txt';

two

pager cat > /home/test.txt;

nopager

three

mysql -p -e "select * from table"  > /home/test/txt