nodejs之MySQL插入数据

const mysql=require(‘mysql’);
//创建链接池
var pool=mysql.createPool({
host:‘127.0.0.1’,
port:3306,
user:‘root’,
password:‘123456’,
database:‘course’, //使用的数据库
connectionLimit:20 //设置连接池的数量
});

//插入数据
pool.query(INSERT INTO user ( id, username, PASSWORD, age, sex, permission, isDelete )VALUES( 4, "lijian", "123456", 18, 1, 0, 0 ),(err,result)=>{
if(err) throw err;
console.log(result);
});

//插入数据方法2
//先用占位符，在数组中输入值
pool.query(INSERT INTO user VALUES(?,?,?,?,?,?,?),[6,“java”,“234”,30,1,0,0],(err,result)=>{
if(err) throw err;
console.log(result);
});

**方法3：命名一个对象，pool.query(SQL语句（INSERT INTO user SET ?），[对象]，回调函数)** //插入对象 var user={ id:7, username:"tom", PASSWORD:"123456", age:76, sex:1, permission:0, isDelete:0 }; pool.query(INSERT INTO user SET ?`,[user],(err,result)=>{
if(err) throw err;
console.log(result);
})