mysql-nodejs v1.6.0

MySQL Nodejs

MySQL-Nodejs is a promise based wrapper of Mysql for easily building up the SQL query.

Connect

Mysql.connect({
    host: process.env.MYSQL_HOST,
    user: process.env.MYSQL_USER,
    password: process.env.MYSQL_PASSWORD,
    database: process.env.MYSQL_DATABASE
});

Mysql.connection
    .on("connected", _ => console.log(`connected to MySQL server`))
    .on("error", error => console.log(error));

Declare your model

const MySQL = require('mysql-nodejs');

const Example = MySQL.model("YourTableName");

Example
    .find()
    .exec()
    .then( res => console.log(res))
    .catch( error => console.log(error))