Mysql Stored Procedure Call Method

The calling method of the mysql stored procedure is frequently used. The following describes the calling method of the mysql stored procedure. It is helpful for you to learn about the mysql stored procedure.

First enter the mysql command line Environment Create a function and select a database. Delimiter $ is set $ as the command termination symbol, instead of the semicolon, because the semicolon has other functions Now restore the semicolon as the Terminator and call the function. Delete A Function In this way, php calls mysql_query ("select quqiufeng ('field name ')"); Stored Procedure Delimiter first $ Call quqiufeng (); // call the mysql Stored Procedure Php call Method

Use of mysql ifnull Functions

MySQL DATEDIFF () syntax

MySQL date functions

Learn more about mysql CONCAT () Functions

MySQL string processing function -- concat () function