howto find the pk of the first and last record in a table

[excession]

Is there a simple way to find the first and the last record in a table?

Or perhaps some way to work through a table accessing each entry at a time?

I'm writing an app to migrate data from one very badly designed database to a new one. I need to read all the data in a table, one row at a time so I can write it to the new db.


Looking for a job as a programmer in Bristol UK.

 

[TonyGroves]

To return the "first" (lowest primary-key value) record in a table, you can use:[tt]
SELECT * FROM tblname ORDER BY keyfldname LIMIT 0,1[/tt]
Then, the next one can be retrieved with:[tt]
SELECT * FROM tblname ORDER BY keyfldname LIMIT 1,1[/tt]
and so on.
The "last" record can be retrieved with:[tt]
SELECT * FROM tblname ORDER BY keyfldname DESC LIMIT 0,1[/tt]