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