Detailed explanation of how to quickly operate MySQL database in nodejs environment

GitHub address: https://github.com/dmhsq/dmhsq-mysql-db
Can be used in Tencent Cloud SCF and cloud development environment Error handling is not yet complete Error reference mysql error Introduce dependency package npm install dmhsq-mysql-db
The effect is as follows: Simplifies the use of MySQL

Install Dependencies

npm install dmhsq-mysql-db

Usage Examples

Quick operation mysql error handling is not yet perfect. For some errors, refer to mysql error

Introducing resources

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

Connecting to a database

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

Reference table

let collection = db.table("user")

Search all

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

Conditional Query

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

Inserting Data

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

Update data

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

Deleting Data

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

This concludes this article on how to quickly operate the MySQL database in a nodejs environment. For more information about how to operate the MySQL database in a nodejs environment, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!