The following articles mainly describe how to create a stored procedure instance in MySQL5. The application frequency of MySQL5 to create a stored procedure is very high. The following describes the instance of MySQL5 to create a stored procedure, I hope this will help you in your future studies.
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.