2 Select database

mysql>use test

3 Query what stored procedures are available in current database

mysql>show procedure status where Db='test'

4 Create a simple procedure

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

5 The procedure is 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)

6 A simple stored procedure succeeds