# MySQL problem

**URL:** <https://forum.kirupa.com/t/mysql-problem/28874>\
**Category:** programming\
**Created:** [August 19, 2003, 5:33pm UTC](https://forum.kirupa.com/t/mysql-problem/28874 "2003-08-19T17:33:29Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![hamza84](https://avatars.discourse-cdn.com/v4/letter/h/ea5d25/32.png) [@hamza84](https://forum.kirupa.com/u/hamza84)\
**Post date:** [August 19, 2003, 5:33pm UTC](https://forum.kirupa.com/t/mysql-problem/28874/1 "2003-08-19T17:33:29Z")

</div>

I’m trying to insert values into a database but I keep getting this mysql error that says

“Duplicate entry ‘0’ for key 1”

Can anybody tell me what this means?

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 19, 2003, 6:49pm UTC](https://forum.kirupa.com/t/mysql-problem/28874/2 "2003-08-19T18:49:03Z")

</div>

it means that there is a duplicate entry where there shouldn’t be. It means that you have the database set up so that certain field can not have duplicate entries. Your best bet is install phpMyAdmin so that you can easily fix and set up your databases…

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 19, 2003, 6:50pm UTC](https://forum.kirupa.com/t/mysql-problem/28874/3 "2003-08-19T18:50:17Z")

</div>

[www.phpmyadmin.net](http://www.phpmyadmin.net) 😉

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 19, 2003, 9:06pm UTC](https://forum.kirupa.com/t/mysql-problem/28874/4 "2003-08-19T21:06:09Z")

</div>

Thanks a bunch for your help guyz.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 22, 2003, 5:57am UTC](https://forum.kirupa.com/t/mysql-problem/28874/5 "2003-08-22T05:57:24Z")

</div>

Each row in a mySQL database must have a unique ID, or primary key. I recommend in your table specfics setting that primary key (which is almost always the first column) to AUTO\_INCREMENT, NOT NULL, and if it isn’t already.

This way, you can write INSERT INTO Table VALUES(’’,‘data’,‘data’…); and your key will auto increment for you and it will be unique.