nodejs环境快速操作mysql数据库的方法详解

npm install dmhsq-mysql-db

const database = require("dmhsq-mysql-db")

let db = new database({
	host: 'xxx',
	port: 'xxx',
	user: 'xxxx',
	password: 'xxxx',
	database: "xxxx"
})

let collection = db.table("user")

collection.get().then(res => {
	console.log(res)
})

collection.where({
	username: "dmhsq"
}).get().then(res => {
	console.log(res)
})

collection.add({
	username: "dmhsq",
	password: "dmhsq",
	_id: 123176312
}).then(res => {
	console.log(res)
})

collection.updata({
	password: "zccc"
}).where({
	username: "dmhsq"
}).then(res=>{
	console.log(res)
})

collection.del().where({
	username: "dmhsq"
}).then(res => {
	console.log(res)
})