CODEWITHSUNDEEP
mysqlsqlmysql-error-1064
djuro djuric
djuro djuric

Reputation: 39

#1062 - Duplicate entry '0' for key 'PRIMARY'

I have a problem with mysql table while try to insert values in database.

I followed this tutorial

http://sqllessons.com/categories.html

and created table like the table from tutorial

table code 

create table categories
( id       integer     not null  primary key 
, name     varchar(37) not null
, parentid integer     null
, foreign key parentid_fk (parentid) 
      references categories (id)
);

error SQL query: Edit Edit

INSERT INTO `mydb`.`categories` (
`id` ,
`name` ,
`parentid`
)
VALUES (
'', 'groceries', NULL
), (
'', 'snacks', NULL
)

MySQL said: Documentation
#1062 - Duplicate entry '0' for key 'PRIMARY'

Help me to solve this.

Upvotes: 2

Views: 12179

Answers (4)

Frivolin
Frivolin

Reputation: 41

Every Primary Key needs to be unique. You inserted 2 rows with the Primary key '0'. Instead of ' ' you should insert an ID.

Edit: Sry my bad, ID not Index.

Upvotes: 0

Gadziu
Gadziu

Reputation: 687

You want to insert an empty value (0) twice to field, that you said is PRIMARY KEY. Primary key from definition has no duplicate.

Upvotes: 0

Riyaz
Riyaz

Reputation: 139

You need to specify the primary key as AUTO_INCREMENT and no need to insert value for 'id' in the query

Upvotes: 0

Gordon Linoff
Gordon Linoff

Reputation: 1269633

Declare the value to be auto incrementing and don't insert it. So:

create table categories (
    id       integer     not null  auto_increment primary key,
    name     varchar(37) not null,
    parentid integer     null,
    foreign key parentid_fk (parentid) references categories (id)
);

And then:

INSERT INTO `mydb`.`categories` (`name`, `parentid`)
    VALUES ('groceries', NULL),
           ('snacks', NULL);

Upvotes: 7

Related Questions