我是Node的新手,正在学习如何从MySQL查询数据。出现以下错误:
错误{[ERROR:ER_BAD_DB_ERROR:未知数据库“201803028”]代码:“ER_BAD_DB_ERROR',错误号:1049,SQLMESSAGE:”未知数据库“201803028”,SQLSTATE:“42000”,FATAL:true}
这是我的代码
const mysql=require('mysql');
var db=mysql.CreateConnection({host:'localhost',用户:'root',密码:'123456',数据库:'201803028'});
db.query(‘select*FROMuser-table
;’,(err,data)=>{if(err){console.log('err',err);}else{console.log('success',data);}})
有谁能告诉我我的编码出了什么问题吗?
非常感谢!
试试这个
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);
});*/