MySQL Forums
Forum List  »  Newbie

Re: Error Code 1062 Duplicate Primary Key
Posted by: Peter Brawley
Date: November 24, 2018 11:20AM

> 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.

Options: ReplyQuote


Subject
Written By
Posted
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.