Step 1: First Create the Stored Procedure in MySQL
Create procedure 'GetStudents' (INT student_id varchar(20))
Begin
select * from student where s_id = student_id;
End
call GetStudents('2');
Create procedure 'GetStudents' (INT student_id varchar(20))
Begin
select * from student where s_id = student_id;
End
call GetStudents('2');