MySQL newbie question: how do I select a row by row number?
I'm new to Mysql and hope this question won't irritate too many people.
I wanna select a row by its row number. I was wondering if there's any function that can do that. Now my table has a column call "id" which was set to autoincrement. "id" can distinguish each row but it can't represent the row number since when we delete one row, "id" won't decrement automatically. So do I need to add another collumn called "rownum" to specify the row number manually?