Absolute position of a record

[albatros21]

Hello,
I am looking for a way to know the exact position of a record in a mysql database.
In order to find it exactly later in my program.
I don't find a mysql function that returns the position of a record.
Thank you for any help.

[Anon]

Use a numeric auto increment column that has a primary key and you can select where id=$id

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Indexes

[kparker]

I don't find a mysql function that returns the position of a record

That's because there isn't one. SQL has no concept of physical data storage at all--that's how it can be so widely used from msql and mysql all the way up to Oracle and DB/2 and not have to change anything.

As far as how to do what you need to do, Mr ProgrammerMan has the answer--create your own uniquely numbered column via auto_increment.