Re: No duplicate records, ignore
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.
Subject
Written By
Posted
November 17, 2020 09:36AM
Re: No duplicate records, ignore
November 17, 2020 11:00AM
November 17, 2020 07:38PM
November 17, 2020 11:58PM
November 18, 2020 05:07AM
November 19, 2020 09:10PM
November 17, 2020 07:37PM
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.