title: How do I make a row generator in MySQL?
body: <p>Is there a way to generate an arbitrary number of rows that can be used in a JOIN similar to the Oracle syntax:</p>
  
  <pre><code>SELECT LEVEL FROM DUAL CONNECT BY LEVEL&lt;=10
  </code></pre>