1.1.1 • Published 8 years ago
node-mysql-connect v1.1.1
node-mysql-wrapper
Simple wrapper with additional functionality over node-mysql.
Install
npm i node-mysql-connect --save
Using
Minimal config:
var config = {
user: '<your_user>',
password: '<your_password>',
database: '<your_database_name>'
};
Include and initialize module:
var connection = require('node-mysql-connect')(config);
Do query:
connection.query("SELECT * FROM <your_table>", function (err, data) {
if (err) throw err;
// working with data ...
});
Query with params:
connection.query("SELECT * FROM <your_table> WHERE a = ? AND b = ?", [a, b], function (err, data) {
if (err) throw err;
// working with data ...
});
Configuration
logger
- enable logging:
var config = {
//...
logger: console.log // for example
};