title: How do I populate a MySQL table with many random numbers?
body: <p>I'm going to ask a question that has been asked in <a href="https://stackoverflow.com/questions/9505930/populate-mysql-table-with-random-data-in-python">very</a> abstract <a href="https://stackoverflow.com/questions/844527/how-to-populate-a-database-column-with-random-numbers">terms</a>, with (understandably) no concrete answers provided:</p>
  
  <p>From the MySQL prompt, how do I create and populate a table, <code>rand_numbers</code>, with one column, <code>number INT</code>, and 1111 rows, where the <code>number</code> column holds a random number between 2222 and 5555?</p>
  
  <p>Something like:</p>
  
  <pre><code>CREATE TABLE rand_numbers(number INT);
  
   #run following line 1111 times
  INSERT INTO rand_numbers (number) VALUES (2222 + CEIL( RAND() * 3333));
  </code></pre>
  
  <p>This question has been asked, but either <a href="https://stackoverflow.com/questions/8551755/postgresql-how-to-efficient-populate-table-with-10-millions-rows-with-random-st">relies</a> on <a href="https://stackoverflow.com/questions/9927933/how-to-insert-random-numbers-mysql">external</a> languages for the loop or is <a href="https://stackoverflow.com/questions/3371503/sql-populate-table-with-random-data">far too general</a>.  I would like to know if it's possible to do something this simple from a typical Linux MySQL prompt.</p>