连接mysql数据库实例
//引入mysql
const mysql = require('mysql')
//设置连接参数
const con = mysql.createConnection({
host:'localhost',
user:'root',
password:'10271027',
port:'3306',
database:'myblog'
})
//连接
con.connect()
//sql语句
const sql = 'select * from users where 1 = 1;'
//执行sql语句
con.query(sql,(err,result)=>{
if(err){
console.log(err)
return
}
console.log(result)
})
//关闭连接
con.end()
console.log('OK')