The ROUTINES table provides information about procedures and functions.
The column named "mysql.proc name" indicates the mysql.proc table column that corresponds to the INFORMATION_SCHEMA.ROUTINES table column, if any.
mysql> desc INFORMATION_SCHEMA.ROUTINES;+--------------------+--------------+------+-----+---------------------+-------+| Field | Type | Null | Key | Default | Extra |+--------------------+--------------+------+-----+---------------------+-------+| SPECIFIC_NAME | varchar(64) | NO | | | || ROUTINE_CATALOG | varchar(512) | YES | | NULL | || ROUTINE_SCHEMA | varchar(64) | NO | | | || ROUTINE_NAME | varchar(64) | NO | | | || ROUTINE_TYPE | varchar(9) | NO | | | || DTD_IDENTIFIER | varchar(64) | YES | | NULL | || ROUTINE_BODY | varchar(8) | NO | | | || ROUTINE_DEFINITION | longtext | YES | | NULL | || EXTERNAL_NAME | varchar(64) | YES | | NULL | || EXTERNAL_LANGUAGE | varchar(64) | YES | | NULL | || PARAMETER_STYLE | varchar(8) | NO | | | || IS_DETERMINISTIC | varchar(3) | NO | | | || SQL_DATA_ACCESS | varchar(64) | NO | | | || SQL_PATH | varchar(64) | YES | | NULL | || SECURITY_TYPE | varchar(7) | NO | | | || CREATED | datetime | NO | | 0000-00-00 00:00:00 | || LAST_ALTERED | datetime | NO | | 0000-00-00 00:00:00 | || SQL_MODE | longtext | NO | | | || ROUTINE_COMMENT | varchar(64) | NO | | | || DEFINER | varchar(77) | NO | | | |+--------------------+--------------+------+-----+---------------------+-------+20 rows in set (0.02 sec)
Name (required)
email (will not be published) (required)
Website
