Connecting MySQL database in flask
import MySQLdb from flask import Flask, render_template, request from flask_mysqldb import MySQL app = Flask(__name__) db = MySQLdb.connect( host = "localhost" , user = "root" , passwd = "" , db = "testdb" ) cur = db.cursor() name = "drago" owner = "rahul" species = "lizard" sql = 'INSERT INTO pet (name, owner, species) VALUES (%s, %s, %s)' cur.execute(sql, (name, owner, species)) db.commit() #fetchone() #executeOne() #fetchmany()