mysql pager
mysql> \P less -S PAGER set to 'less -S' mysql> select * from user;
mysql> \P grep test | less -S PAGER set to 'grep test | less -S' mysql> select * from user;
mysql> \P cat > ~/dump.txt PAGER set to 'cat > ~/dump.txt' mysql> select * from user;
$ mysql --pager='less -S' -uroot -p