node调用mysql数据库_Node 操作 MySQL 数据库

1、安装

Linux 版

Mac 版

2、使用 Sequelize

一般会有两个依赖： mysql2 驱动和 Sequelize ORM 框架

const Sequelize = require("sequelize");

const config = require("./config");

// 第一步：建立 ORM 连接

var sequelize = new Sequelize(

config.database,

config.username,

config.password,

{

host: config.host,

dialect: "mysql",

pool: {

max: 5,

min: 0,

idle: 30000

}

}

);

// 第二步：建立 Model

var Pet = sequelize.define(

"pet",

{

id: {

type: Sequelize.STRING(50),

primaryKey: true

},

name: Sequelize.STRING(100),

gender: Sequelize.BOOLEAN,

birth: Sequelize.STRING(10),

createdAt: Sequelize.BIGINT,

updatedAt: Sequelize.BIGINT,

version: Sequelize.BIGINT

},

{

timestamps: false

}

);

var now = Date.now();

// 第三步：利用 Model 创建实例

Pet.create({

id: "g-" + now,

name: "Gaffey",

gender: false,

birth: "2007-07-07",

createdAt: now,

updatedAt: now,

version: 0

})

.then(function(p)