```sql （1）查看数据库 learn_mysql 下有哪些存储过程 # 建议全部大写 mysql> SELECT SPECIFIC_NAME FROM INFORMATION_SCHEMA.ROUTINES -> WHERE ROUTINE_SCHEMA = 'LEARN_MYSQL' AND ROUTINE_TYPE = 'PROCEDURE'; +------------------+ | SPECIFIC_NAME | +------------------+ | proce_login_user | | proce_user01 | | proce_user02 | | proce_user03 | +------------------+ （2）查看存储过程基本信息 mysql> show procedure status like 'proce_login_user'; +-------------+------------------+-----------+----------------+-----. .. | Db | Name | Type | Definer | Modified | ... +-------------+------------------+-----------+----------------+-----. .. | learn_mysql | proce_login_user | PROCEDURE | root@localhost | 20... +-------------+------------------+-----------+----------------+ ... （3）查看存储过程定义信息 mysql> show create procedure proce_login_user; +------------------+--------...---------------------------------------+--... | Procedure | sql_mode ... | Create Procedure ... +------------------+--------...---------------------------------------+--... | proce_login_user | ONLY_F...255), CREATE DEFINER=`root`@`localhost` PROCEDURE `proce_login_user`(in uname varchar(255), in pass varchar(255), out result int) begin select count(1) into result from `user` where password=pass and username=uname; end | ... +-------... ```