基于NodeJs操作MySQL实现基础操作

基于NodeJs操作MySQL实现基础操作

---

实现数据库的增删改查

---

代码篇

const mysql = require('mysql');

const connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: '1234567890',
    database: 'Demo'
});

connection.connect();

var addSql = 'INSERT INTO profile(student) VALUES(?)';
var addSqlParams = ['菜鸟工具2212121'];
//增
connection.query(addSql, addSqlParams, function (err, result) {
    if (err) {
        console.log('[INSERT ERROR] - ', err.message);
        return;
    }

    console.log('--------------------