nodejs -mysql模块链接数据库创建库创建表单。

var mysql = require('mysql');

var connection= mysql.createConnection({

host:'localhost',

user:'root',

password:'',

port:3306,

database:'mydb'

});

connection.connect(function(err){

if(err){

console.log("链接失败");

throw(err)

}else{

console.log("链接成功");

connection.query("CREATE TABLE person(id int,user varchar(255),password varchar(255))", function(err,result){

if(err){throw err}else{

console.log("创建表成功")

}

})

}

})