#db = pymysql.connect(**PY_MYSQL_CONN_DICT)
cursor = db.cursor(cursor=pymysql.cursors.DictCursor)
#https://www.cnblogs.com/iber/p/7735002.html
cursor.callproc('OPERATION_PROCEDURE',([536288]))
res1 = cursor.fetchall()
#https://blog.csdn.net/appleyuchi/article/details/79492086
# 执行SQL,并返回收影响行数
sql="select OPERATION_FUNCTION(536288,100)"
effect_row = cursor.execute(sql)
res1 = cursor.fetchall()
# 提交,不然无法保存新建或者修改的数据
db.commit()
# 关闭游标
cursor.close()
其他范例可能会出现的错误:
TypeError: 'int' object is not iterable
或者:
PROCEDURE does not exist