Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var mysql= require('mysql');
- var client = mysql.createClient({
- user: 'root',
- password: 'root',
- host: 'localhost'
- });
- client.query('USE sample');
- for(var k=0;k<=100;k++)
- {
- var sql="SELECT `id` FROM `data` WHERE `id`= ?";
- console.log(k);
- client.query(sql,[k],function(err,results,field){
- console.log("DATABASE "+k);
- if(results.length == 0) {
- var sql2="INSERT INTO `data` (`id`) VALUES (?);";
- client.query(sql2,[k],function(err,results,field){
- });
- }
- });
- }
- client.end();
Add Comment
Please, Sign In to add comment