Here's a nice stackoverflow answer as to how to display row numbers in a mySql query. (I am perplexed how is this a missing feature both in mySql Workbench and in the proprietary sqlYog).
Seems you can declare variables within queries and use them, on the fly. You may need, this, someday.
