i have a table like this
when i run query like this
I am getting #1062 - Duplicate entry '1' for key 1
can any one guide me correct way declare columns
Thanks for advance
You have tagged your question with both Sql-Server-2005 and MySql. The error message looks like MySql, which I'm not very good at, but I'll give it a shot.
It looks on the error message like you have a unique constraint or a primary key constraint (having the same effect in this case) on the column Bouncer_Id. In that case, it's logical that you can't insert a duplicate value. If bouncer_id should not be unique, change or drop the constraint on the column.
answered Nov 20, 2012 at 07:08 AM