title: Select incremented integer
body: <p>I want to know if it's possible to select incremented integer from mysql table? and if it does possible, how can I achieve that?</p>
  
  <p>My case is, I have a bunch of data and I need to do <code>INSERT INTO newtable ... SELECT somefield FROM sometable</code>. However, there is one field on <code>newtable</code> called <code>counter</code> that I need it in incremented integer, eg:</p>
  
  <pre><code>row #1: counter=1
  row #2: counter=2
  row #3: counter=3
  row #4: counter=4
  row #5: counter=5
  row #6: counter=6
  ... and so on...
  </code></pre>
  
  <p>I can do this using simple php script, but I want to try to do it all from mysql query. So, can you guys tell me if it's possible?</p>