Advertisement
Guest User

Untitled

a guest
Apr 8th, 2016
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. var sqlconfig = {
  2.   host: '127.0.0.1',
  3.   user: 'ootwuser',
  4.   password: 'asdf',
  5.   database: 'ootw',
  6.   multipleStatements: true
  7. };
  8.  
  9. // Get the lib
  10. var mysql = require("mysql");
  11.  
  12. var con = mysql.createConnection(sqlconfig);
  13.  
  14. con.connect(function(err){
  15.   if(err){
  16.     console.log('Error connecting to Db');
  17.     console.log(err);
  18.     return;
  19.   }
  20.   console.log('Connection established');
  21. });
  22.  
  23. con.query(
  24.     'here your sql',
  25.     [/*parameter],
  26.     function(err, result) {
  27.         if(err) throw err;
  28. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement