sync-mysql
Make synchronous queries to a mysql database
Installation
npm install sync-mysql --save
Usage
var MySql = ; var connection = host: 'localhost' user: 'me' password: 'secret'; const result = connection;;
API
connection.getRecord(tableName, id)
Assuming that the table passed has an id
column, get the record with that id.
connection.query(str, values)
Return an array of objects from a SQL query. The query may optionally contain ?s to be replaced with escaped values from values which should be an array.
connection.call(name, args)
Call a database procedure. If it returns only one set of values, that set of values is returned as an array of objects. If it returns multiple sets of values then they are returned as an array.
License
MIT