1.下载mysql模块和co-mysql模块 co-mysql用于封装mysql简化mysql模块的不断回调,使异步执行同步写法与async,await配合使用
cnpm i mysql -D
cnpm i co-mysql -D2.引入sql模块
const mysql = require('mysql');
const co-mysql = require('co-mysql');3.连接数据库
let conn = mysql.createPool({host:'localhost',user:'root',password:'root',database:'nodejs'});
let db = co(conn);//包装mysql 4.简单查询
db.query('select * from user',(err,data)=>{
if(err){
console.log('错误')
console.log(err);
}else{
//返回数组加对象
console.log('成功')
console.log(data)
}
});
5.创建连接池
let db = mysql.createPool({
host:,usr:,passowrod:,database:
})