Nodejs uses Sequelize-auto to generate the model based on the table of the database

1. Open cmd Command window, install Sequelize-auto

NPM install-g Sequelize-auto

Need to install global MySQL before using Sequelize-auto (example MySQL)

NPM install-g MySQL

2. Database New Table

Then run Sequelize-auto-o "./mysqltest"-D db-h localhost-u root-p 3306-x root-t user-e MySQL

User.js is generated in the Mysqltest directory (the model for the user table)

3. Copy the User.js to the node project to use

See website:

52640401

Https://www.npmjs.com/package/sequelize-auto

Nodejs uses Sequelize-auto to generate the model based on the table of the database