Create a detailed instance of a stored procedure in MySQL5
Use the mysql tutorial client to log on
2. Select database tutorial
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, the php tutorial 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.