MySQL Forums
Forum List  »  Oracle

Oracle ROWID equivalent in MySQL
Posted by: tetri mesquita
Date: May 18, 2010 12:52PM

Good afternoon,

I have a log table that doesn't have a PK.
There was just over 12 million records and I'm developing a program that select the records one by one, insert into an Oracle table and delete the record in MySQL.
Since I don't have a PK, I have to delete the records based on all fields of the table. This process is time consuming!

I can't create a PK in this log table to solve the problem. However, in Oracle, you can delete the records using the ROWID. There is such information in MySQL?

Jr. Programmer

Options: ReplyQuote

Written By
Oracle ROWID equivalent in MySQL
May 18, 2010 12:52PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.