node.js - 在 mysql phpmyadmin 中找不到表

Question

我在 mysql phpmyadmin.i 中创建了一个数据库，将 Canvas 作为数据库，将学生作为表。我使用 Sequelize 创建了一个 ORM，它一直说找不到表我正在使用 postman 发布到表它应该给我电子邮件和消息的回复。这是 postman 错误，正在收到 errorSequelizeDatabaseError: Table 'canvas.students' doesn't exist 谢谢。

这是我的 db.js

const Sequelize = require('sequelize');
const db = {}
const sequelize = new Sequelize('canvas', 'root', 'root', {
    host: 'localhost',
    port: 8889,
    dialect: 'mysql',
    operatorAliases: false,

    pool: {
        max: 5,
        min: 0,
        acquire: 3000,
        idle: 10000
    }
})
db.sequelize = sequelize
db.Squelize = Sequelize

module.exports = db;

这是我的模特

 const Sequelize = require('sequelize');
const db = require('../database/db.js')

module.exports = db.sequelize.define(
    'student', {
        id: {
            type: Sequelize.INTEGER,
            primaryKey: true,
            autoIncrement: true
        },
        name: {
            type: Sequelize.STRING
        },
        email: {
            type: Sequelize.STRING
        },
        password: {
            type: Sequelize.STRING
        },
        created: {
            type: Sequelize.DATE,
            defaultValue: Sequelize.NOW
        }
    }, {
        timestamps: false
    }

)

Answer 1

module.exports = db.sequelize.define(
'student', {
    id: {
        type: Sequelize.INTEGER,
        primaryKey: true,
        autoIncrement: true
    },
    name: {
        type: Sequelize.STRING
    },
    email: {
        type: Sequelize.STRING
    },
    password: {
        type: Sequelize.STRING
    },
    created: {
        type: Sequelize.DATE,
        defaultValue: Sequelize.NOW
    }
}, {
    timestamps: false


  }

)

这一行 - 'student', { 在你的模型定义中 student 是表名不是 student 因此错误 - Table 'canvas.students' 不存在