Oracle ROWID equivalent in MySQL
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?
--
TETRI MESQUITA
Jr. Programmer
Subject
Views
Written By
Posted
Oracle ROWID equivalent in MySQL
10996
May 18, 2010 12:52PM
29469
August 04, 2010 07:44AM
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.