环境:ubuntu16.04
首先要在数据库中建立好存储过程:
http://blog.csdn.net/appleyuchi/article/details/79491299
然后开个sublime,代码如下
# -*- 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='employees', charset='utf8')
# 创建游标
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
#有参数存储过程
cursor.execute('call pr_add(%s,%s)',(10,20))
data = cursor.fetchall()
conn.commit()
print"data=",data
cursor.close()
print '调用存储过程完毕................'
conn.close()
运行结果:
data= [{u'sum': 30}]
调用存储过程完毕................
[Finished in 0.1s]