**pip install pymysql** **pip install flask_sqlalchemy** ### app.py ``` from flask import Flask from flask import render_template ,url_for ,request from flask_sqlalchemy import SQLAlchemy app = Flask(__name__) app.config.from_object('config') db=SQLAlchemy(app) class user2(db.Model): id=db.Column(db.Integer, primary_key=True) username=db.Column(db.String(80), unique=True) email = db.Column(db.String(120), unique=True) @app.route('/', methods=['GET', 'POST']) def hello_world(): if(request.method == 'POST'): username=request.form['username'] email=request.form['email'] user = user2(id=1, username=username, email=email) db.session.add(user) db.session.commit() return "update" else: return render_template('test.html') if __name__ == '__main__': app.run() ``` ### templates > test.html ``` <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <form action="/" , method="post"> <label for="username">username:</label><br> <input type="text" name="username" value="John"><br> <label for="email">email:</label><br> <input type="text" name="email" value="Doe"><br><br> <input type="submit" value="Submit"> </form> </body> </html> ``` ### config.py ``` SQLALCHEMY_DATABASE_URI = "mysql+pymysql://root:password@localhost:3306/flask" SQLALCHEMY_TRACK_MODIFICATIONS = "False" # SQLALCHEMY_POOL_RECYCLE = 299 # SQLALCHEMY_POOL_TIMEOUT = 20