# -*- coding: UTF-8 -*-
# Author  :  LinYaoHong
# Date    :  2019/8/19 15:36
# Filename:  03-1-pymysql调用存储过程.py
# Tools   :  PyCharm
'''
-- 创建传参存储过程
CREATE PROCEDURE p2(
	IN n1 int,
	IN n2 int
	)
BEGIN
	SELECT * FROM student WHERE sid >n1;
END;
'''

import pymysql
conn = pymysql.connect(host='localhost',
                       port=3306,
                       user="root",
                       password='111111',
                       db="test",
                       charset='utf8')
cursor = conn.cursor()  # 游标

a = 4566
cursor.callproc('p4', (a, 8))
result = cursor.fetchall()
print(result)

cursor.execute('select @_p4_0,@_p4_1')
result = cursor.fetchall()
print(result)

conn.commit()
cursor.close()
conn.close()