Duplicate entry '' for key 2----what does this mean?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
LynneM
Forum Newbie
Posts: 4
Joined: Thu Jan 15, 2004 3:24 pm
Location: Pensacola, FL

Duplicate entry '' for key 2----what does this mean?

Post by LynneM »

Duplicate entry '' for key 2

I'm getting this error when I try to submit more than one form to the database. Can't seem to locate the problem.

Using Dreamweaver MX, PHPadmin, MySQL.
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

It means you have a column that is a primary key/unique key/autoincrement type and you're trying to insert an non unique value.
LynneM
Forum Newbie
Posts: 4
Joined: Thu Jan 15, 2004 3:24 pm
Location: Pensacola, FL

Post by LynneM »

thanks. It was a unique column problem.
Post Reply