title: How to display mysql query result one screen at a time
body: <p>I'd like to display result of my queries page by page, for example I have a Mysql db with a lot of tables and I need to see the result of <code>show tables;</code> as one screen at a time, similar to <a href="https://en.wikipedia.org/wiki/More_(command)" rel="nofollow">more command</a>. I know I can do a  <code>mysql mydb -u username -p -e 'show tables;' | more</code> but I need it inside inside db shell (MySQL Command-Line Tool).</p>
  
  <p>So simple but I couldn't find it</p>