node.js操作MySQL

var mysql = require('mysql')
var connection = mysql.createConnection({
    host:'localhost',
    port:3306,
    database:'test',
    user:'root',
    password:'root'
})

connection.connect(function(err){
    if(err){
        console.log('与MySQL建立连接失败')
    }else{
        console.log('与MySQL数据库建立连接OK')
        connection.query('insert into test set ?',{username:'abcd',passsword:'123456'},function(err,result){
            if(err){
                console.log('插入数据失败')
            }else{
                connection.query('select * from ??',['test'],function(err,result){
                    if(err){
                        console.log('查询数据失败')
                    }else{
                        console.log(result)
                        connection.end()
                    }
                })
            }
        })
    }
})
##################执行结果
os@ubuntu:/mnt/osmysql$ node test1.js 
与MySQL数据库建立连接OK
[ RowDataPacket { id: 1, username: 'abcd', passsword: '123456' },