nodejs链接mysql数据库，执行简单的增删改查操作

var mysql = require('mysql');
var conn = mysql.createConnection({
host: 'localhost',
user: 'root',
password: '',
database:'nodejs',
port:
});
conn.connect();//查询
// conn.query('SELECT * from user where name="wangzhiwei"', function(err, result) {
// if (err) throw err;
// console.log(result);
// })//新增
// conn.query('insert into user (username,password) values("huxiaona","123456")', function(err, result) {
// if (err) throw err;
// console.log(result);
// })//删除
// conn.query('delete from user where username="wupeigui"', function(err, result) {
// if (err) throw err;
// console.log(result);
// })conn.query('update user set id="1" where username="huxiaona"',function(err,result){
if (err) {throw err};
console.log("修改数据成功");
})conn.end();