phpMyAdmin error #1062 - Duplicate entry '1' for key 1

mysql phpmyadmin mysql-error-1062
Webne picture Webne · Jul 22, 2010 · Viewed 63.4k times · Source

I am not sure why I am getting this error #1062 - Duplicate entry '1' for key 1 cany any one help explain what it means. Thanks

Answer

bradenkeith picture bradenkeith · Jul 22, 2010

More than likely your column is set to be Unique, and you're trying to input a row with an ID that already exists in your table.

Related questions

phpmyadmin error "#1062 - Duplicate entry '1' for key 1"

I dropped all tables from a database then restore(import) a backup. Afterwards I am getting error #1062 - Duplicate entry '1' for key 1. Should i repeat the process. Or something else? Why this error is coming?

Read More
MySQL PHPMyAdmin Error #1062 - Duplicate entry '0' for key 'PRIMARY'

Now I want to add a primary key id column but it throws the error: #1062 - Duplicate entry '0' for key 'PRIMARY' I already tried this: Add primary key to existing table

Read More
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I installed LAMP on Ubuntu 12.04 LTS (Precise Pangolin) and then set root password on phpMyAdmin. I forgot the password and now I am unable to login. When I try to change password through terminal I get: ERROR 2002 (HY000): Can't connect …

Read More