title: How do I make a SQL table from the result of another select?
body: <p>I'm asking for MySQL specifically, but the answer might work for a lot of SQL databases.</p>
  
  <p>If I have a select statement like this:</p>
  
  <pre><code>select * from users where age &gt; 5;
  </code></pre>
  
  <p>How do I assign that to a new table?</p>