title: Is there an easy way to create a table with 500000 (dummy/zero/empty) rows
body: <p>I want to do something that sounds so easy, but I was not able to find an easy way to solve it:<br />
  Create a new table with, let's say, 500000 rows and get them numbered automatically (ID).</p>
  <p>Using PHP it's probably a simple loop, but I wonder if it is really necessary to use PHP.</p>
  <p>I am almost sure there is a simple solution using a MySQL command or even with phpMyAdmin.</p>