SQL IN Parameters

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

delimiter $$

create procedure abc(IN a int)
BEGIN 
	SET @x = a;
END$$
delimiter ;

Call Procedure

call Procedure name is used to execute the procedure.

call abc(123);

Fetch variable value

Fetch Variable (@value) return you the value of parameter in the Query.

select @a;

Result

+------+
| @x   |
+------+
| 123  |
+------+