Stored Procedure in MySql

in SQL Workbench

CREATE DEFINER=`root`@`localhost` PROCEDURE `GetStudent`(IN id int )

BEGIN

select * from student where idstudent = id ;

END

In python

try:

import mysql.connector

from mysql.connector import MySQLConnection, Error

mydb = mysql.connector.connect(host="localhost",user="root",password="password",database="dbname")

n=mydb.cursor(buffered=True,dictionary=True)

i=int(input("Enter student rollno: "))

result_args = n.callproc('GetStudent',[i,])

for result in n.stored_results():

cnl = [x[0] for x in result.description]

rd = [dict(zip(cnl,row)) for row in result.fetchall()]

for r  in rd:

for item in r:

print(item,":",r[item])

except Exception as e:

print(e)

finally:

n.close()