List:General Discussion« Previous MessageNext Message »
From:Karthik Date:August 27 2002 5:26am
Subject:Re: ERROR 1062
View as plain text  
this query in all probability violates some referential integrity... and
this in all probability is a primary key defined in your table.

So please check whether the query is trying to insert duplicate values in a
primary key field

----- Original Message -----
From: "Osman Omar" <osman@stripped>
To: "MySQL" <mysql@stripped>
Sent: Tuesday, August 27, 2002 10:46 AM
Subject: ERROR 1062


> Hi
>
> I get this error.
>
> any idea?
>
>
> mysql> insert into emcs (insp_date,judge_date,model,lot_no,remark)
> values
>     -> (20020816,20020816,'TA-SL5','010','');
> ERROR 1062: Duplicate entry '127' for key 1
> mysql>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread118034@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-karthik=maximizelearning.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

Thread
ERROR 1062Osman Omar27 Aug
  • Re: ERROR 1062Karthik27 Aug
    • Re: ERROR 1062Osman Omar27 Aug
      • Re: ERROR 1062Dan Nelson27 Aug
        • Re: ERROR 1062Osman Omar27 Aug