Re: using Insert Ignore for a specific column only
That is exactly right. I am using mysqlworkbench and RDS. I just want to be sure that if someone tries to insert a row with an already existing email+campaign that I don't throw a 1062 Duplicate Entry Error.
"if I try to insert a row that would break unique together after using this method, it throws an '1062 Duplicate entry' error."
My plan is to go to mysqlworkbench and:
Go to Indexes tab.
Double-click on a blank row to create a new index.
Choose 'UNIQUE' as the index type.
Check the columns that you want to be unique together (email and campaign)
see any issues?
thx
Subject
Written By
Posted
November 06, 2022 04:32PM
November 07, 2022 08:14AM
November 07, 2022 08:59AM
November 08, 2022 05:03AM
November 08, 2022 06:27AM
November 08, 2022 07:04AM
November 08, 2022 07:50AM
Re: using Insert Ignore for a specific column only
November 08, 2022 08:06AM
November 09, 2022 06:21AM
November 09, 2022 07:26AM
November 09, 2022 08:24AM
November 09, 2022 08:29AM
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.