MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

ORACLE UNIQUE INDEX COLUMN1,COLUMN2 VS UNIQUE COLUMN1,COLUMN2 MYSQL
Posted by: Azhar Mat Zin
Date: January 26, 2024 03:09AM

I have an interesting problem.

There was a table with CREATE UNIQUE INDEX SCHEMA.COULMN1,COLUMN2 in Oracle with 500 data, for example.

I have created the same table in MySQL, UNIQUE DB.COULMN1,COLUMN2 and only around 420 rows get inserted because I'm getting
"ERROR 1062 (23000): Duplicate entry" error.

But when I create a clone of the same table in Oracle, including index, I use insert as select and all 500 data got inserted.

How does MySQL handle UNIQUE DB.COULMN1,COLUMN2 compared to Oracle CREATE UNIQUE INDEX SCHEMA.COULMN1,COLUMN2 ?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
ORACLE UNIQUE INDEX COLUMN1,COLUMN2 VS UNIQUE COLUMN1,COLUMN2 MYSQL
Azhar Mat Zin
January 26, 2024 03:09AM
Re: ORACLE UNIQUE INDEX COLUMN1,COLUMN2 VS UNIQUE COLUMN1,COLUMN2 MYSQL
Barry Galbraith
January 28, 2024 11:19PM


Sorry, only registered users may post in this forum.
Click here to login

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.