Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

duplicate key error

Status
Not open for further replies.

arm207

Programmer
Jun 13, 2006
26
0
0
US
hi,
would anyone know what the cause of the following symptom is...

Fatal error: MySQL error: 1062 : Duplicate entry '0-1-1' for key 1 in

why is it not allowed to have multiple entries with same value?
 
You seem to have a unique index defined on that field. A unique index prevents duplicate values for the field it's associated with. If you're sure it's not needed, you can get rid of it by first finding out its name with a SHOW CREATE TABLE comand, then dropping it with an ALTER TABLE ... DROP INDEX command.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top