Duplicate Entry "id" for key 1

[Anon]

Hello,
The table has primary key id.In this table, I couldn't insert new record and gives the following error message
ERROR 1062😃uplicate entry "1234" for key 1
Then,i used ALTER as follows

Alter ignore table tablename unique index id (id,col1,col2,coln);

but still getting the same error..

i need to confirm two things
1. the table has primary key id autoincrement, so how does it happened to create Duplicate Entry
2. Is there solution without recreating the table

Wkr,
Vijayarekha

[khaine]

If the key is on auto increment then just pass it an empty string.

so instead of doing

insert into table values ("12345", "name");

try

insert into table values ("", "name");

the sql should be bright enough to sort out the next number in the sequence.

Mark.