title: MySQL the command line and pagers
body: <p>I cant find anything about this from searching here. </p>
  
  <p>I use mysql on the command line at work and I work with fairly large tables so I set the mysql pager allowing a more readable result if I run a query, that returns 1000's of results. I use the command below to set the pager.</p>
  
  <pre><code>\P less -Sin
  </code></pre>
  
  <p>This suits my needs but has left me wondering if there are any more pager styles that mysql uses on the command line.</p>