MySQL5 create a stored procedure instance _ MySQL

MySQL5 create a stored procedure instance the following articles mainly introduce the demo of MySQL5 create a stored procedure instance. the application frequency of MySQL5 to create a stored procedure is still very high, the following is a detailed description of the instance used to create a stored procedure in MySQL5. I hope this will help you in your future study.

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 results 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. Therefore, use these new functions, it is best to use the mysqli php Extension Library

The usage of the function is similar, that is, an additional return value. the above content is an introduction to MySQL5's creation of a stored procedure instance. I hope you will gain some benefits.

The above content describes how to create a stored procedure instance in MySQL5, hoping to help you in this regard.