Guest User

Untitled

a guest
Jan 23rd, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. var mysql= require('mysql');
  2.  
  3. var client = mysql.createClient({
  4. user: 'root',
  5. password: 'root',
  6. host: 'localhost'
  7. });
  8.  
  9. client.query('USE sample');
  10.  
  11. for(var k=0;k<=100;k++)
  12. {
  13.  
  14. var sql="SELECT `id` FROM `data` WHERE `id`= ?";
  15.  
  16. console.log(k);
  17.  
  18. client.query(sql,[k],function(err,results,field){
  19.  
  20. console.log("DATABASE "+k);
  21. if(results.length == 0) {
  22.  
  23. var sql2="INSERT INTO `data` (`id`) VALUES (?);";
  24.  
  25. client.query(sql2,[k],function(err,results,field){
  26.  
  27. });
  28.  
  29. }
  30. });
  31.  
  32. }
  33.  
  34. client.end();
Add Comment
Please, Sign In to add comment