Re: Error Code 1062 Duplicate Primary Key
> With the above I get: Error Code: 1136. Column count doesn't match value count at row 1
Because there is no column coresponding to null.
> I remove Null and that seemed to work for that Error but then I get Error Code: 1062. Duplicate entry '1' for key 'PRIMARY'
Because you already inserted the above rows. To remove them, issue ...
truncate pres_term;
And since term start and end tomes aren't usually available or relevant, those datetime columns ought probably to be dates.
Subject
Written By
Posted
November 24, 2018 11:03AM
Re: Error Code 1062 Duplicate Primary Key
November 24, 2018 11:20AM
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.