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))