Create a stored procedure instance using mysql5

1. Log On with the mysql client. 2. Select a database.

Mysql> use test

3. query the stored procedures of the current database.

Mysql> show procedure status where DB = 'test'

4. Create a simple Stored Procedure

Mysql> Create procedure HI () Select 'hello ';

5. After the storage process is created, see how to call it.

Mysql> call hi ();

Display result

Mysql> call hi (); + ------- + | Hello | + ------- + | Hello | + ------- + 1 row in SET (0.00 Sec) Query OK, 0 rows affected (0.01 Sec)

6. A simple stored procedure is successful. This is just a demonstration. The stored procedure can execute multiple SQL statements at a time. Therefore, PHP can query multiple statements only once when connected to the database; however, to return multiple result sets, you must use the mysqli extension for query. Otherwise, the error can't return a result set in the given context will be prompted.
So to use these new features, it is best to use the mysqli PHP extension library.

Function usage is similar, that is, a return value is added.