MySQL Forums
Forum List  »  Newbie

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

Quote

How do I let Mysql (7) know that it is only a matching employee_email that it needs ignore?

Why do you feel the need to do this at all?

The uniqueness of employee_email is probably enforced by a unique index.
That constraint is probably there for a Good Reason.

I would suggest that you should find out what that Reason is before trying to simply "ignore" it!

For example, it is very common these days to uniquely identify Users by their email address. If your system does this, then introducing duplicate email addresses is likely to cause a lot of problems.

Regards, Phill W.

Options: ReplyQuote




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.