Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var mysql = require('mysql');
- var mclient = mysql.createConnection({
- host: settings.MYSQL.HOST,
- user: settings.MYSQL.USER,
- password: settings.MYSQL.PASSWORD,
- database: settings.MYSQL.DB,
- });
- var mysql = require("mysql");
- var pool = mysql.createPool(/* credentials go here */);
- exports.getConnection = function(callback) {
- pool.getConnection(function(err, conn) {
- if(err) {
- return callback(err);
- }
- callback(err, conn);
- });
- };
- var mysqlLib = require("mysqlLib");
- mysqlLib.getConnection(function(err, mclient) {
- //do queries that you need
- });
- var mysqlLib = require("mysqlLib");
- mysqlLib.getConnection(function(err, mclient) {
- //do queries that you need
- var sql = '//Your SQL here';
- var inserts = [your inserts here];
- sql = mysql.format(sql, inserts);
- mclient.query(sql, function (err, rows) {
- if (err) {
- //handle error here
- }
- })
- });
Add Comment
Please, Sign In to add comment