Node.js 连接Mysql的增删改查操作简单例子

var mysql = require('mysql');var connection = mysql.createConnection({    host: 'localhost',    user: 'root',    password: '123456',    database: 'test'});connection.connect();// var sql = 'select * from basetable';// var sql = 'insert into basetable value(2,"yuan")'// var sql ='update basetable set id = 3 , name = "chan" where id = 2'// var sql = 'delete from basetable where id = 3';connection.query(sql,function(err,result){    console.log(result);});connection.end();