npm i --save sequelize sequelize-cli mysql2
npx sequelize-cli init
將會產生以下文件夾
打開config/config.json,修改資料庫連線資訊
{
"development": {
"username": "root",
"password": null,
"database": "database_development",
"host": "127.0.0.1",
"dialect": "mysql"
},
"test": {
"username": "root",
"password": null,
"database": "database_test",
"host": "127.0.0.1",
"dialect": "mysql"
},
"production": {
"username": "root",
"password": null,
"database": "database_production",
"host": "127.0.0.1",
"dialect": "mysql"
}
}
利用npx產生我們第一張使用者資料表,預期會有name, email, password等欄位並且都是字串型別
npx sequelize-cli model:create --name User --attributes name:string,email:string,password:string
將會產生以下文件