Auto increment a value on the fly

By assigning a value to a variable in MySQL and incrementing the variable as part of a select statement, it's possible to have a number auto-incremented on the fly. This number has no other reference to the table other than the order the data is selected. It is also possible to auto increment the variable when running an update statement so a new set of incrementing values could be stored into the table.