nodejs：本地nodejs连接mysql 实现 增、删、改、查

 连接数据库：

var mysql = require("mysql");

var connection = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "snowball",
    database: "runoob_test",
  });

  connection.connect((err)=>{
      if(err) throw err;
      console.log('链接成功')
  });

 查询数据表：

var mysql = require("mysql");

var connection = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "snowball",
    database: "runoob_test",
  });

  connection.connect((err)=>{
      if(err) throw err;
      console.log('链接成功')
  });
  // console.log('connection:', connection)
  // conn.query(sqlStr[,params],callback)
  // sqlStr:要执行的sql语句，可以使用占位符
  // params:参数列表，数组
  // callback:回调函数，第一个参数：异常对象；第二个参数：结果对象
  // SELECT * FROM要大写
  // 查询数据表runoob_tbl
  let sql = 'SELECT * FROM runoob_tbl'
  connection.query(sql, function (error, results, fields) {
    if (error) throw error;
    console.log('The solution is: ', results);
  });
  // https://www.runoob.com/nodejs/nodejs-mysql.html

 插入数据行：

var mysql = require("mysql");
var moment = require('moment');

var connection = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "snowball",
    database: "runoob_test",
  });

  connection.connect((err)=>{
      if(err) throw err;
      console.log('链接成功')
  });
  // console.log('connection:', connection)
  // conn.query(sqlStr[,params],callback)
  // sqlStr:要执行的sql语句，可以使用占位符
  // params:参数列表，数组
  // callback:回调函数，第一个参数：异常对象；第二个参数：结果对象
  // SELECT * FROM要大写
  // 查询
  // let sql = 'SELECT * FROM runoob_tbl'
  // connection.query(sql, function (error, results, fields) {
  //   if (error) throw error;
  //   console.log('The solution is: ', results);
  // });
  // 插入
  // 注意参数、值，个数要正确，格式要正确
  console.log(moment().format("YYYY-MM-DD HH:mm:ss"));
  // var  addSql = 'INSERT INTO runoob_tbl(runoob_id,runoob_title,runoob_author,submission_date) VALUES(2,?,?,?)';
  var  addSql = 'INSERT INTO test_tb2(title,name) VALUES(11,22)';
  // var  addSqlParams = ['菜鸟工具', 'https://c.runoob.com','23453'];
  connection.query(addSql,function (err, result) {
    if(err){
      console.log('[INSERT ERROR] - ',err.message);
        return;
    }
      console.log('INSERT-success');
  })

  // https://www.runoob.com/nodejs/nodejs-mysql.html

 改：

var mysql = require("mysql");
var moment = require('moment');

var connection = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "snowball",
    database: "runoob_test",
  });

  connection.connect((err)=>{
      if(err) throw err;
      console.log('链接成功')
  });
  var modSql = 'UPDATE test_tb2 SET title = ?,name = ?';
  var modSqlParams = ['nameTest', 'titleTest'];
  //改
  connection.query(modSql,modSqlParams,function (err, result) {
     if(err){
           console.log('[UPDATE ERROR] - ',err.message);
           return;
     }
    console.log('UPDATE affectedRows',result.affectedRows);
  });



  // https://www.runoob.com/nodejs/nodejs-mysql.html

 删除：

var mysql = require("mysql");
var moment = require('moment');

var connection = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "snowball",
    database: "runoob_test",
  });

  connection.connect((err)=>{
      if(err) throw err;
      console.log('链接成功')
  });
  var delSql = 'DELETE FROM test_tb2 where title=title';
  //改
  connection.query(delSql,function (err, result) {
     if(err){
           console.log('[DELETE ERROR] - ',err.message);
           return;
     }
    console.log('DELETE affectedRows',result.affectedRows);
  });



  // https://www.runoob.com/nodejs/nodejs-mysql.html

问题处理：

  

 继续尝试后未解决问题：

检查后发现SELECT * FROM没有大写，大写后问题解决

let sql = 'SELECT * FROM runoob_tbl'

字段不能是sql关键字否则报错，如：desc

参考链接：

nodejs连接mysql报错throw err; // Rethrow non-MySQL errors解决方法 - 代码先锋网

nodejs连接mysql报错：throw err； // Rethrow non-MySQL errors_Luminous★的博客-CSDN博客

MYSQL插入日期数据报错：“Error: ER_TRUNCATED_WRONG_VALUE: Incorrect date value: ‘2020-03-01T16:00:00.000Z’ for_爱酱丶的博客-CSDN博客

nodejs的moment操作时间_老汉的微笑的博客-CSDN博客_moment nodejs

Node.js 连接 MySQL | 菜鸟教程

node连接mysql_Node连接mysql数据库方法_Cherry丶晓的博客-CSDN博客

ER_PARSE_ERROR: You have an error in your SQL syntax check the manual that corresponds to your MySQL_@小傲哥哥的博客-CSDN博客

Nodejs如何连接数据库操作数据_小猪佩祁的博客-CSDN博客_node连接数据库

ER_PARSE_ERROR: You have an error in your SQL syntax check the manual that corresponds to your MySQL_@小傲哥哥的博客-CSDN博客

mysql数据库表字段使用DESC等关键字报错及解决方法_Turn X7的博客-CSDN博客_mysql 字段名为desc