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" <[EMAIL PROTECTED]> > To: "MySQL" <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php