mysql - 如何通过Node从MySQL中查询数据

Question

我是 Node 新手，正在学习如何从 MySQL 查询数据。我收到以下错误:

err { [Error: ER_BAD_DB_ERROR: Unknown database '201803028'] code: 'ER_BAD_DB_ERROR', errno: 1049, sqlMessage: 'Unknown database \'201803028\'', sqlState: '42000', fatal: true }

这是我的代码

const mysql = require('mysql');

var db = mysql.createConnection({ host:'localhost', user:'root', password:'123456', database:'201803028'});

db.query('SELECT * FROM user-table;',(err,data)=>{ if(err){ console.log('err',err); }else{ console.log('success',data); } })

谁能告诉我我的编码出了什么问题？

非常感谢!

Answer 1

试试这个

var mysql = require('mysql')
var connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'yourpassword',
  database : 'yourdatabasename'
})

connection.connect();
/* Uncomment the below query to test your connction
connection.query('SELECT 1 + 1 AS solution', function (error, results, fields) {
  if (error) throw error;
  console.log('The solution is: ', results[0].solution);
});*/