MySQL Forums
Forum List  »  MySQL Workbench

REPLACE INTO (INSERT)
Posted by: GANESA KUMAR
Date: September 14, 2022 06:01AM

Hi Team,

I have written data integration stored procedure.
There I have used REPLACE INTO (INSERT) STATEMENT .
(Assumed all the target table is having UNIQUE KEY)

Since all my target table is FACT kind of table , I won't have any primary key, only I can create composite unique key.

But new case has come, One target table has been created with 20 columns. Here is the problem come into picture . I could not create UNIQUE KEY for more than 16 columns (Composite UNIQUE KEY).

Now how can i handle this situation?

I don't want to write separate delete and insert .


Please advice for my cases and let me know if need more information.

Options: ReplyQuote


Subject
Views
Written By
Posted
REPLACE INTO (INSERT)
40
September 14, 2022 06:01AM


Sorry, only registered users may post in this forum.

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.