問題描述：

在用flask模型來創(chuàng)建數(shù)據(jù)表的時(shí)候報(bào)錯(cuò)：ProgrammingError: (_mysql_exceptions.ProgrammingError) (1146, "Table 'tflask.user' doesn't exist") [SQL: u'SELECT count(%s) AS count_1 \nFROM user'] [parameters: ('*',)] (Background on this error at: http://sqlalche.me/e/f405)

解決方案：

該錯(cuò)誤意思是需要?jiǎng)?chuàng)建的表不存在，查看了代碼：

db = SQLAlchemy(app)
db.init_app(app)
db.create_all()
 
class User(db.Model, UserMixin):
    __tablename__ = 'user'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True, nullable=False)
    username = db.Column(db.String(20), nullable=False)
    password_hash = db.Column(db.String(30), nullable=False)

db.create_all()放在了模型User之前，所以沒有創(chuàng)建到該表，應(yīng)該把其放在要?jiǎng)?chuàng)建表的后面

db = SQLAlchemy(app)
db.init_app(app)
 
class User(db.Model, UserMixin):
    __tablename__ = 'user'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True, nullable=False)
    username = db.Column(db.String(20), nullable=False)
    password_hash = db.Column(db.String(30), nullable=False)

db.create_all()

然后查看數(shù)據(jù)庫，該表創(chuàng)建成功