Re: using Insert Ignore for a specific column only

[Phillip Ward]

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.