MYSQL5 Create a stored procedure

1 Login with MySQL client

2 Select Database

mysql>use test

3 What stored procedures are queried for the current database

mysql>show procedure status where Db='test'

4 Create a simple stored procedure

mysql>create procedure hi() select 'hello';

5 stored procedure created, see How to call it

mysql>call hi();

Show results　　mysql> call hi();
+-------+
| hello |
+-------+
| hello |
+-------+
1 row in set (0.00 sec)
　　Query OK, 0 rows affected (0.01 sec)

61 Simple storage process is successful, this is just a demo, stored procedures can execute multiple SQL statements at a time, so PHP only connected to the database can query multiple statements at once, but to return multiple result sets must use MYSQLI extension to query, or will be prompted error can ' t return a Result set in the given context

So to use these new features, it's best to adapt to the PHP extension library using MYSQLI.