simple-mysql-query

simple-mysql-query

simple mysql query with promise

install

npm i simple-mysql-query

usage

const query = require('simple-mysql-query');

set config in main file

query({
	host : '127.0.0.1',
	port : '3306',
	user : 'root',
	password : 'root',
	database : 'db'
})

query simple sql in other files

query({
	sql : 'select * from table where name=? ',
	params : ['name']
}).then(rs => {
	const list = rs[0];
	console.log(list);
}).catch(e => console.log(e));

query multi sql in other files

query([{
	sql : 'select * from table where name=? ',
	params : ['name']
},{
	sql : 'select * from table2 where name=?',
	params : ['name']
}]).then(rs => {
	const list = rs[0];
	console.log(list);
	const list2 = rs[1];
	console.log(list2);
}).catch(e => console.log(e));

license

MIT LICENSE