List:General Discussion« Previous MessageNext Message »
From:Osman Omar Date:August 27 2002 6:13am
Subject:Re: ERROR 1062
View as plain text  
below is my tables properties, 
and my last record id is 127;

mysql> desc emcs;
+------------+-------------+------+-----+------------+----------------+
| Field      | Type        | Null | Key | Default    | Extra          |
+------------+-------------+------+-----+------------+----------------+
| id         | tinyint(6)  |      | PRI | NULL       | auto_increment |
| insp_date  | date        |      |     | 0000-00-00 |                |
| judge_date | date        |      |     | 0000-00-00 |                |
| model      | varchar(20) |      |     |            |                |
| lot_no     | varchar(5)  |      |     |            |                |
| remark     | text        | YES  |     | NULL       |                |
+------------+-------------+------+-----+------------+----------------+
6 rows in set (0.02 sec)

mysql> 

On Tue, 2002-08-27 at 13:26, Karthik wrote:
> 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