Simple examples of storage functions and stored procedures in MySQL, mysql stored procedures

Simple examples of storage functions and stored procedures in MySQL, mysql stored procedures
Storage Function Definition

Create function 'fn _ Sum' ('A' int, 'B' int) RETURNS int (11) BEGIN RETURN a + B; END

 

Call the call in Navicat

 

 

Running result:

 

 

SQL call

SELECT fn_sum (1, 2 );

Running result:

 

 

Calls in Java

Abbreviation :"{? = Call fn_sum (?,?)} "

 

Stored Procedure Definition with input parameters

Create procedure 'in _ param' (in p_in int) BEGIN SELECT p_in; END

 

Call the call in Navicat

 

 

Running result:

 

 

SQL call

CALL in_param (2 );

Running result:

 

 

Calls in Java

Abbreviation: "{call in_param (?)} "

 

Stored Procedure Definition with output parameters

Create procedure 'out _ param' (out p_out int) BEGIN SELECT p_out; SET p_out = 2; SELECT p_out; END

 

Call the call in Navicat

 

 

Running result:

 

 

 

SQL call

CALL out_param (@ p_out );

Running result:

 

 

 

Calls in Java

Abbreviation: "{call out_param (?)} "