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

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

multithreading - Exception in Application constructor -

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -