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

Popular posts from this blog

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

-
i have method method discussed , successful data entered 1 when more 1 can not database this programs my php form : <form class="form-horizontal" id="form-produk"> <div class="control-group" > <label class="control-label" for="kelas">kategori</label> <div class="controls"> <select class='form-control' name='id_kategori'> <?php $tampil=mysql_query("select * kategori order nama_kategori"); if ($id_kat==0){ echo "<option value=0 selected>- pilih kategori -</option>"; } while($w=mysql_fetch_array($tampil)){ if ($id_kat==$w[id_kategori]){ echo "<option value=$w[id_kategori] selected>$w[nama_kategori]</option>"; } else{ echo "<option value=$w[id_kategori]>$...
Read more

c++ - How to test/verify that zero-initialization takes place -

-
i trying test 0 initialization on virtual machine g++ options -std=c++98, -std=c++03, -std=c++11 unfortunately there not many garbage values , see zeros in place shouldn't be. how force random values can test this? #include <iostream> #include <string> using namespace std; class { public: int a; }; class b { public: b(){} int x; }; int main() { { int tab[50000] = {0}; } a; a* aa = new a; b b; b* bb = new b; cout << a.a << endl; cout << aa->a << endl; cout << b.x << endl; cout << bb->x << endl; return 0; } you not guaranteed see random numbers. c/c++ standard says uninitialized values undefined, cannot values have. 0 ok (maybe virual machine zeros memory before allocating). if need random numbers, generate them using <random>
Read more

node.js - Webpack/TypeScript Raising Errors When node_modules is Excluded -

-
Image
i have following webpack , typescript configs: webpack.config.js module.exports = { entry: { dev: './src/ts/site' }, output: { filename: './com/js/site.js' }, resolve: { extensions: ['', '.ts', '.tsx'] }, module: { loaders: [ // typescript { test: /\.tsx?$/, loader: 'ts-loader' } ] } } tsconfig.json { "compileroptions": { "noimplicitany": true, "module": "commonjs" } } i've simplified project include following dependencies: package.json (partial) "typescript": "^1.7.5", "ts-loader": "^0.7.2", "webpack": "^1.12.9" when run webpack, massive slew of errors: the list goes on many many screen lengths, far i've scrolled every 1 duplicate identifier err...
Read more