title: MySQL - row number in recordset?
body: <p>First of all, I'm not asking how to get the current row number after the results have been return to you.</p>
  
  <p>I'm wondering, is it possible to get the row number as one of the returned columns in MySQL results? What I'm trying to do is to add a number to increments up to every single row. Like this:</p>
  
  <pre><code>| id | myNum | name |
  +----+-------+------+
  | 34 |     1 | John |
  | 24 |     2 | Alex |
  | 56 |     3 | Brad |
  etc...
  </code></pre>
  
  <p>I'm guessing it would involve stored procedures, but I'm wondering if it's possible without them...</p>