MySQL Forums
Forum List  »  Newbie

Re: using Insert Ignore for a specific column only
Posted by: Phillip Ward
Date: November 08, 2022 07:50AM

Quote

... the email entered by the administrator to identify an employee.

Identifying implies uniqueness.
No employee should be using the same email address to work for more than one company (that's just a Data Breach waiting to happen!).

Quote

Can I index on two fields to stop dupes?

Yes, you can but just be aware that this is recording a different relationship.
An employee probably can take part in any number of campaigns, but each campaign only once, so a unique index on ( campaign, employee_email ) would cover that.

Regards, Phill W.

Options: ReplyQuote




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.