title: MySql Generating a column of values
body: <p>In SQL statement in MySql it is easy to create a row of values on fly by using somethig like</p>
  <blockquote>
  <p>SELECT 1, 2, 3, 4, 5, 6, 7, 8, 9, 10;</p>
  </blockquote>
  <p>this will generate a single row containing numbers from 1 to 10 but is it possible to have a single column that contains these values.</p>