#1062 - Duplicate entry for key 'PRIMARY'

mysql sql mysql-error-1062
irosenb picture irosenb · Jul 24, 2012 · Viewed 259.4k times · Source

So my MySQL database is behaving a little bit wierd. This is my table:

Name shares id  price   indvprc
cat   2     4   81      0
goog  4     4   20      20
fb    4     9   20      20

I'm getting this #1062 error when I try to insert into the table. So I looked into it further and realized that when I try to insert values into the table, in which the name and shares values are the same, it will return the #1062 error. For example, If i inserted: 

fb    4      6     20   20

It would return an error. But if i changed the shares number to 6, it would run fine. Is it because of one of my columns that could be unique, or is it just something with mysql?

Answer

mlishn picture mlishn · Jul 24, 2012

You need to remove shares as your PRIMARY KEY OR UNIQUE_KEY

Related questions

MySql can't make column auto_increment

I have a table "Bestelling" with 4 columns: "Id" (PK), "KlantId", "Datum", "BestellingsTypeId", now I want to make the column Id auto_increment, however, when I try to do that, I get this error: ERROR 1062: ALTER TABLE causes auto_increment resequencing, …

Read More
MySQL: Duplicate Entry for Key 2

I'm not sure what I'm doing to cause this error. The query: INSERT INTO node (type, language, title) VALUES ('bout', 'en', 'the title 3') The error: #1062 - Duplicate entry '0' for key 2 The table: CREATE TABLE `node` ( `nid` int(10) …

Read More
#1062 - duplicate entry '' for key 'primary'

Table 1 - leads column 1 - lead_source_description Table 2 - leads_cstm column 2 -referrer_c I am trying to copy values from table2.column2 to table1.column1 using the following query INSERT INTO leads (`lead_source_description`) SELECT `referrer__c` …

Read More