【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