[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1295
  • Last Modified:

Rowid in MySQL

Can I use rowid in MySQL like in Oracle???
1 Solution
Dave BaldwinFixer of ProblemsCommented:
Apparently not.  Several posts on the MySQL forum say no.  http://forums.mysql.com/read.php?61,368131,379277#msg-379277
Atique AnsariCommented:
Mohamed AbowardaSoftware EngineerCommented:
There is no rowid in MySQL.

The best thing you could do is to define a surrogate primary key with an auto_increment field, and use that to reference your row for subsequent updates.
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

verinsisAuthor Commented:
A auto_increment field isnĀ“t the solution because I need a key over all tables in database, not only over one table.
Guy Hengel [angelIII / a3]Billing EngineerCommented:
MySQL does not have rowid.
if you need a "globally unique" id for any row, you could assign a GUID value to a dedicated column (but still would be your own code)
however, given such a GUID, you cannot locate the row as such, as still you would need to know the table it would be in.

you might want to explain the "global picture" about your requirement?
verinsisAuthor Commented:

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now