SQL IN Parameters

This page discusses - SQL IN Parameters

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)
	SET @x = a;
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;


| @x   |
| 123  |