MySQL Forums
Forum List  »  General

Re: No duplicate records, ignore
Posted by: Peter Brawley
Date: November 17, 2020 11:00AM

I do not understand "where dt and temp are unique (but not unique keys)". Insert Ignore need a Primary or Unique index on criterion column(s).

Consider posting the result of Show Create Table... for the table.



Edited 1 time(s). Last edit at 11/17/2020 11:52PM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
November 17, 2020 09:36AM
Re: No duplicate records, ignore
November 17, 2020 11:00AM


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.