NodeJS
操作MySQL
-
安装
mysql
模块npm install mysql
-
引入
mysql
模块const mysql = require('mysql')
-
创建连接
const connection = mysql.creatConnection({ host: 'localhost', user: 'root', password: 'sercet', database: 'demo' })
-
连接数据库
connection.connect()
-
数据操作(CURD)
// connection.query(sql语句, callback(错误对象, 结果集, 相关信息集)) connection.query('SELECT * FROM `test`', function (err, results, fields){ if (err) throw err console.log(results) console.log(fields) })
-
断开连接
connection.end()