【python 调用储存过程】python 执行储存过程

# -*- coding:utf-8 -*- import sys reload(sys) sys.setdefaultencoding('utf-8') import pymysql conn=pymysql.connect(host='localhost',port=3306,user='root',password='12345',db='cgjr', charset='utf8') # 创建游标 cursor = conn.cursor(cursor=pymysql.cursors.DictCursor) #有参数存储过程 cursor.execute('call add_teacher(%s)',(10)) conn.commit() cursor.close() print '调用存储过程完毕................' conn.close() 调用存储过程完毕................ Process finished with exit code 0