title: How to INSERT INTO a range of numbers into a MYSQL table
body: <p>How would I insert a range of numbers into a MYSQL table? I'm missing something very obvious!</p>
  
  <p>Here's my example: </p>
  
  <p><strong>MYSQL</strong></p>
  
  <pre><code>INSERT INTO stock_figures (product_id)
  VALUES (13275 BETWEEN 13341)
  </code></pre>
  
  <p>I want to insert into the <code>product_id</code> column all of the numbers between 13275 and 13341 inclusive.</p>
  
  <p>Can somebody please assist? 
  Thanks</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>I would like to avoid creating a procedure or a temporary table as this is only being used for a single query. I feel this qualifies as different enough to not be marked as a duplicate. </p>