MySQL Forums
Forum List  »  Oracle

How to skip the validation of primary Key in MYSQL
Posted by: krishna kumar
Date: July 10, 2018 03:48PM

i am trying to migrate the database from oracle to MYSQL. Oracle has duplicate values in a table, i am assuming primary key might have been enabled with novalidate option. Could someone guide me the equivalent method to perform the same in MYSQL.

Note:- i have tried 'alter table table_name add primary key (column1, column2) enable novlidate' , but this didnt work.

Options: ReplyQuote


Subject
Views
Written By
Posted
How to skip the validation of primary Key in MYSQL
2250
July 10, 2018 03:48PM


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.