Mysql命令结果重定向相关

来自WILO & 三线的随记
跳到导航跳到搜索

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