MySQL Pager Trick

I got tired of always having to set the pager (\P) in mysql cli, so I set up an alias in my bash profile:


alias mysql="mysql --pager='less -niS'"

Now, I get nice tabular formatted output in my queries.