MySQL stored procedures

1. Create a stored procedure

MySQL>  delimiter $mysql>Createprocedure  pro_user ()     begin,         Select* from  Tb_user;      - End $

2. View stored procedures for the current database

MySQL> use book;

Mysql>Showprocedurestatus;+------+-------------+-----------+----------------+---------------------+---------------------+--------------- +---------+----------------------+----------------------+--------------------+|Db|Name|Type|Definer|Modified|Created|Security_type|Comment|Character_set_client|Collation_connection| DatabaseCollation|+------+-------------+-----------+----------------+---------------------+---------------------+--------------- +---------+----------------------+----------------------+--------------------+|Book|Findallbook| PROCEDURE |Root@localhost |  .- the-Geneva  One: -: to |  .- the-Geneva  One: -: to |Definer|         |Gbk|Gbk_chinese_ci|Utf8_general_ci||Book|Pro_test| PROCEDURE |Root@localhost |  .- One- -  ,: -: - |  .- One- -  ,: -: - |Definer|         |Gbk|Gbk_chinese_ci|Utf8_general_ci||Book|Pro_user| PROCEDURE |Root@localhost |  .- One- -  ,: -: the |  .- One- -  ,: -: the |Definer|         |Gbk|Gbk_chinese_ci|Utf8_general_ci|+------+-------------+-----------+----------------+---------------------+---------------------+--------------- +---------+----------------------+----------------------+--------------------+3Rowsinch Set(0.01Sec

MySQL stored procedures