how to find the record no?

[busybeeitsme]

hi friends

how to find the record no.. ie what is the location of the particular record in the database.. i dont hav any s.no column in my database.. if a particular record is retrived from the table i have to show its position in the database in my page. can anybody help me? is there any query for this?

thanks in advance

[Atli]

Hi.

How is your table designed? Could we see the CREATE TABLE statement you used?

Rows do not have a default "position" within a table.
If you want to be able to pinpoint a particular row, you will have to add a column that allows you to do so.

Integer Primary Key columns with the Auto_Increment parameter set are very good for this purpose. They give you a row-count of sorts, which you can refer to in other tables and applications.

Like:

`ID` Int Unsigned Not Null Auto_Increment Primary Key

[busybeeitsme]

actually i dint create any new table.. currently i am doin a project for an organisation.. already they have the database in ms-access.. and it contains merely 7000 records.. now i ve converted this database to mysql using a software.. in access database they dint have any auto-increment column!! thats is the problem.. so should i include this column in my database???

[Atli]

That depends on your current table structure.
Is there a primary key?

Try executing this command and posting the results here:

SHOW CREATE TABLE `<tablename>`;

Where <tablename> is the name of your table.
(If you do this via the mysql CLI client, you can use \G at the end of the query rather than the semi-colon to get a cleaner output.)

This should give you a CREATE TABLE command that can be used to create the table.