var mysql = require("mysql");
var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : 'liyong123.',
database : 'node'
});
function add(){//增
var post = {user:'web2',pass:123321,id:2};
var query = connection.query("INSERT INTO login SET ?",post,(err,results,fields)=>{
if(err) throw err;
})
console.log(query.sql);
connection.end();
}
function select(){//查
connection.connect((err)=>{
if(err){
console.log(err.stack);
return;
}
console.log(connection.threadId);
})
connection.query("SELECT * FROM login",(err,result,firlds)=>{
if(err) throw err;