A parameter is a placeholder that accept a user-defined value, whenever stored procedure is executed.
Understand with Example
This Example shows you how to use in type parameters. The Tutorial illustrates an example, which create a procedure 'abc' and accept input parameter. The input parameter allows the invoker to pass the data into the procedure.
create procedure abc(IN a int) BEGIN SET @x = a; END$$ delimiter ;
call Procedure name is used to execute the procedure.
Fetch variable value
Fetch Variable (@value) return you the value of parameter in the Query.
+------+ | @x | +------+ | 123 | +------+
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.