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
is there rowid concept in mysql
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?
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.
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();