npm install sequelize sequelize-cli -S --registry&＃61;https://registry.npm.taobao.org
在 node 环境 src 文件夹下 mkdir db 进入 db
修改 srcdbconfigconfig.json 文件夹下的 mysql 配置 例如&＃xff1a;
{"development": {"username": "root","password": "admin","database": "koa2_dictionary","host": "127.0.0.1","dialect": "mysql","timezone": "&＃43;08:00"},"production": {"username": "root","password": null,"database": "database_production","host": "127.0.0.1","dialect": "mysql","operatorsAliases": false}
}
srcdbmodelsindex.js &＃xff08;先增加2行注释内容。后期同步用&＃xff0c;现在不加也可以&＃xff09;
// 更新表字段 &＃43; 备注
// sequelize.sync({ alter: true });
db.sequelize &＃61; sequelize;
db.Sequelize &＃61; Sequelize;module.exports &＃61; db;
创建模型&＃xff1a; 需要 cd 到 db 下执行
npx sequelize-cli model:generate --name User --attributes firstName:string,lastName:string,email:string
执行迁移&＃xff1a;执行后不出意外&＃xff0c;会在数据库下生成 users 和 sequelizemeta 两个表
npx sequelize-cli db:migrate
撤销迁移&＃xff1a;还原到最近的一个迁移
npx sequelize-cli db:migrate:undo
撤销迁移&＃xff1a;撤销所有迁移
npx sequelize-cli db:migrate:undo:all
Sequelize 中文文档整理&＃xff08;v5版本&＃xff09;itbilu.com
京公网安备 11010802041100号