Folks, I've had a database running for months now and suddenly, when inserting into table 'HEARTBEAT_COUNTS' (desc below), I get an error:
Error - Duplicate key '444642', -1 (The syntax of the error message is not exact) My insert statement does not include a value for 'id' which is an auto_increment field. The table has about 390,000 rows. Please help -- I'll answer any question ASAP as I really want to understand why this happened. I have temporarily dropped the table and created a new one and the problem disappeared -- but I want to learn why it happened and how I can prevent it. Thank you very much. -- CREATE TABLE `heartbeat_counts` ( `id` int(10) unsigned NOT NULL auto_increment, `received_responses` smallint(5) unsigned NOT NULL default '0', `device_response` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM ; example insert: INSERT INTO heartbeat_counts set received_responses=1, device_response=12951 ; __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
