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

# -*- coding:utf-8 -*-import sysreload(sys)sys.setdefaultencoding('utf-8')import pymysqlconn=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