Python调用mysql存储过程

Python调用mysql存储过程

import pymysql

conn = pymysql.connect(host= '127.0.0.1',port = 3306,
                       user = 'root',password = 'root',
                       database = 'test',charset = 'utf8')
cur = conn.cursor()
cur.callproc('T1')  # 调用存储过程
conn.commit()
result = cur.fetchall()

print(result)

conn.close()
``