title: Alias to Show Tables MySQL Result
body: <p>When executing SHOW TABLES FROM <em>your_db_name_here</em> inside MySQL, the result has <em>Tables_in_{your_db_name_here}</em> as its indexes. I'd like to change that, like this:</p>
  
  <pre><code>SHOW TABLES as _tables FROM mydb;
  </code></pre>
  
  <p>or something like</p>
  
  <pre><code>SELECT Tables_in_mydb AS _tables FROM (SHOW TABLES FROM mydb);
  </code></pre>
  
  <p>Any ideas?</p>