MySQL Tutorial/Data Dictionary/proc

proc

   <source lang="sql">

mysql> desc proc; +------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------------------+-------+ | db | char(64) | NO | PRI | | | | name | char(64) | NO | PRI | | | | type | enum("FUNCTION","PROCEDURE") | NO | PRI | | | | specific_name | char(64) | NO | | | | | language | enum("SQL") | NO | | SQL | | | sql_data_access | enum("CONTAINS_SQL","NO_SQL","READS_SQL_DATA","MODIFIES_SQL_DATA") | NO | | CONTAINS_SQL | | | is_deterministic | enum("YES","NO") | NO | | NO | | | security_type | enum("INVOKER","DEFINER") | NO | | DEFINER | | | param_list | blob | NO | | | | | returns | char(64) | NO | | | | | body | longblob | NO | | | | | definer | char(77) | NO | | | | | created | timestamp | NO | | CURRENT_TIMESTAMP | | | modified | timestamp | NO | | 0000-00-00 00:00:00 | | | sql_mode | set("REAL_AS_FLOAT","PIPES_AS_CONCAT","ANSI_QUOTES","IGNORE_SPACE","NOT_USED","ONLY_FULL_GROUP_BY","NO_UNSIGNED_SUBTRACTION","NO_DIR_IN_CREATE","POSTGRESQL","ORACLE","MSSQL","DB2","MAXDB","NO_KEY_OPTIONS","NO_TABLE_OPTIONS","NO_FIELD_OPTIONS","MYSQL323","MYSQL40","ANSI","NO_AUTO_VALUE_ON_ZERO","NO_BACKSLASH_ESCAPES","STRICT_TRANS_TABLES","STRICT_ALL_TABLES","NO_ZERO_IN_DATE","NO_ZERO_DATE","INVALID_DATES","ERROR_FOR_DIVISION_BY_ZERO","TRADITIONAL","NO_AUTO_CREATE_USER","HIGH_NOT_PRECEDENCE") | NO | | | | | comment | char(64) | NO | | | | +------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------------------+-------+ 16 rows in set (0.02 sec) mysql> use test Database changed</source>