SELECT incrementing value

[neoform]

is there a way to do something like this?

 

SELECT val1, val2, an_incrementing_value FROM table1 LIMIT 100

 

where the incrementing value starts at 0 and goes up to 99 (as a way to number the results).

 

I'm using this in an INSERT SELECT, so the incrementing field needs to be done by mysql.

[Simon Moon]

From your example, i assume you want that for printing it out. I would simply do that in the script, by counting up the numbers and not in the database.

[fenway]

Don't number the results on INPUT.