mysql - Inserting values into a table which is composite primary key with 3 columns, those colums are foreign keys -
my table looks this:
create table tbluserfollower ( userid int foreign key references tblusers(userid), followerid int foreign key references tblusers(userid), subcourseid int foreign key references tblsubcourse(subcourseid), statusid int foreign key references tblstatus(statusid), isactive bit not null, createddate datetime default getdate(), createdby nvarchar(50) default 'admin', updateddate datetime default getdate(), updatedby nvarchar(50) default 'admin', primary key(userid, followerid, subcourseid) ) i want write stored procedure insert values table.
Comments
Post a Comment