python文件存储过程_pymysql存储过程代码

import pymysql

conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', password='666', db='sqlexample',charset='utf-8')

cursor = conn.cursor(cursor=pymsql.cursor.DictCursor)

#执行存储过程，获取存储过程的结果集，将返回值设置给了@_存储过程名_序号 =

r1 = cursor.callproc('p11', args=(1, 22, 3, 4))

# set @_p11_0 = 1

# set @_pll_1 = 22

# set @_p11_2 = 3

# set @_p11_3 = 4

# call p11(1, 22, 3, 4)

print(r1)

result1 = cursor.fetchall()

print(result1)

#获取执行完整存储的参数

r2 = cursor.execute("select @_p11_0,@_p11_1,@_p11_2,@_p11_3")

print(r2)

result2 = cursor.fetchall()

print(result2)

conn.commit()

cursor.close()

conn.close()