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