Connect to MySQL database and create user model

2. Installing and configuring the Python3.6+flask+mysql database
   1. Download and install MySQL database
   2. Download and install Mysql-python middleware
   3. Pip Install Flask-sqlalchemy (Python's ORM Framework SQLAlchemy)
4. MySQL CREATE database
6. Database configuration Information config.py
8. Build MySQL and App connections
9. Create a user model

    fromflask Import Flaskimport config fromflask_sqlalchemy Import Sqlalchemyapp=Flask (__name__) app.config.from_object (config) DB=SQLAlchemy (APP)classUser (db. Model): __tablename__='User'ID= db. Column (db. Integer, Primary_key=true, autoincrement=True) Username= db. Column (db. String ( -), nullable=False) Password= db. Column (db. String ( -), nullable=False) Nickname= db. Column (db. String ( -) ) Db.create_all () @app. Route ('/') def hello_world ():return 'Hello world!'if__name__ = ='__main__': App.run ()

   config.py

   ' Mysql+pymysql://root:@127.0.0.1:3306/mis_db?charset=utf8 '  = False

Connect to MySQL database and create user model