index.js

const mysql = require('mysql')

// 创建链接对象
const con = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'wuchendi',
  port: '3306',
  database: 'myblog',
})

// 开始连接
con.connect()

// 执行 sql 语句
// const sql = "select * from users";
// const sql = "select id, username from users";
// const sql = `SELECT * FROM users WHERE state='1'`;
// const sql = `UPDATE users set state='0' WHERE username='wcd'`;
// const sql = `update users set realname='wuchendi3' where username = 'wcd1'`;
const sql = `insert into blogs (title, content, createtime, author) values ('标题', '内容',1560818599043, 'wuchendi')`
con.query(sql, (err, result) => {
  if (err) {
    console.error(err)
    return
  }
  console.log(result)
})

// 关闭连接
con.end()

package.json

{
  "name": "mysql-test",
  "version": "1.0.0",
  "description": "",
  "main": "index.js",
  "scripts": {
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "keywords": [],
  "author": "",
  "license": "ISC",
  "dependencies": {
    "mysql": "^2.16.0"
  }
}