注意先安装对应库mysql-python

#coding:utf-8

import MySQLdb
import ssl
#支持HTTPS
ssl._create_default_https_context = ssl._create_unverified_context

db = MySQLdb.connect("localhost", "user", "passwd", "dbname")
SQ = db.cursor()
SQ.execute("SET NAMES utf8")

#增删改数据
def doSql(sqls):
    try:
        SQ.execute(sqls)
        db.commit()
    except:
        db.rollback()

#查询一条数据，返回的是数组
def getSql(sqls):
    try:
        SQ.execute(sqls)
        Sres=SQ.fetchone()
        return Sres
    except:
        return False

##################

db.close()