is there rowid concept in mysql

[ramas]

I found no rowid in mysql.Rowid is in oracle which generates unique id for a row. Is there anything equivalent to this in mysql?
Any one helps me in this is appreciated.
thanks

[Pig]

I'm not familiar with Oracle. When designing a table, you should have a column, specifically for ID, which is autonumbered. There is no function for it, but it is part of how you should design a database. Is that what you mean?

[nemonoman]

Hi. I'm familiar with both Oracle and MySQL. There is no MySQL equivalent to an Oracle rowid. One must create workarounds to replace that helpful function; typically by creating and then capturing the content of a unique identifier for the row.

[vponz]

For create an unique row identifier you must create a column like this:

CREATE TABLE TABLE_NAME (
ID INT(10) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
...
...
)

If you want to know what ID assigns MySql after inserting a row you must run this query:
Select last_insert_id();