import pymysql
db = pymysql.connect("192.168.50.231", "root", "1234", "datasir")
# 四个参数依次代表:IP地址,mysql的账号和密码,数据库的名称
cursor = db.cursor()
sql = """select SUM(DpstBal)
FROM t_rep_dpstcust_sec
where BrtCod='21020' and Dtadat='2017-10-01' """
try:
cursor.execute(sql)
db.commit()
print(12)
except:
db.rollback()
print(34)
db.close
注: 若显示,权限不足,则需要在数据库开放权限