mysql - Msg 2627 Violation of PRIMARY KEY constraint -

mysql - Msg 2627 Violation of PRIMARY KEY constraint -

trying create database teams in tv show here. when seek , insert info tblshowteam next error made appearance.

msg 2627, level 14, state 1, line 2 violation of primary key constraint 'pk__tblshowt__f693078c03317e3d'. cannot insert duplicate key in object 'dbo.tblshowteam'.

tables

-- tabbellen aanmaken create table tblshow( setid int, datum date, teams int primary key (setid)); create table tblshowteam( setid int, datum date, teams int, primary key (teams)); create table tblteam( teamid int, coach varchar(35), coachid int, teams int primary key (coachid)); -- participant table create table tbldeelnemer( deelnemerid int identity(1, 1), deelnemerv varchar(35), deelnemert_v varchar(10), deelnemera varchar(35), coachid int, datum_optreden date primary key (deelnemerid)); --table public viewers create table tblkijker( kijkerv varchar(35), kijkert_v varchar(10), kijkera varchar(35), stoelnummer int identity(1,3), showid int not null, email varchar(35) primary key (email));

my inserts this:

insert tblshowteam values (1, '2014-06-28', 1) insert tblshowteam values (2, '2014-06-05', 1) insert tblshowteam values (3, '2014-06-12', 1) insert tblshowteam values (4, '2014-06-19', 1) insert tblshowteam values (5, '2014-06-26', 1)

all other inserts (in diffrent tables) work normal.

what doing wrong here?

your problem here

primary key (teams));

i guess have that

primary key (setid));

like that:

create table tblshowteam( setid int, datum date, teams int, primary key (setid));

because inserting same teams 1 while using teams primary key means no duplicates.

mysql sql database duplicates primary-key