MYSQL Stored Procedure for incoming and outgoing Parameters

The following describes the stored procedures for calling input parameters and stored procedures for outgoing parameters in the MYSQL stored procedure called by PHP. The Calling method is for your reference, hope to help you.

MYSQL Stored Procedure for input parameters
$ SQL ="
Create procedure myproce2 (in score int)
Begin
If score> = 60 then
Select 'pass ';
Else
Select 'no ';
End if;
End;
";
Mysql_query ($ SQL); // create a stored procedure of myproce2
$ SQL = "call test. myproce2 (70 );";
Mysql_query ($ SQL); // call the stored procedure of myproce2. The result is invisible. You can see the result in cmd.

MYSQL Stored Procedure for outgoing Parameters
$ SQL ="
Create procedure mypropushed (out score int)
Begin
Set score = 100;
End;
";
Mysql_query ($ SQL); // create a stored procedure of myproc4
$ SQL = "call test. myproc4( @ score );";
Mysql_query ($ SQL); // call the stored procedure of myproc4
$ Result = mysql_query ('select @ score ;');
$ Array = mysql_fetch_array ($ result );
Echo '<pre>'; print_r ($ array );
 

Mysql Stored Procedure Call Method

Use of mysql ifnull Functions

Learn more about MySQL GROUP_CONCAT Functions

MySQL date functions

Provides you with an in-depth understanding of the MYSQL Cast function.