SELECT * FROM `ROUTINES`
|
SPECIFIC_NAME | ROUTINE_CATALOG | ROUTINE_SCHEMA | ROUTINE_NAME | ROUTINE_TYPE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | DTD_IDENTIFIER | ROUTINE_BODY | ROUTINE_DEFINITION | EXTERNAL_NAME | EXTERNAL_LANGUAGE | PARAMETER_STYLE | IS_DETERMINISTIC | SQL_DATA_ACCESS | SQL_PATH | SECURITY_TYPE | CREATED | LAST_ALTERED | SQL_MODE | ROUTINE_COMMENT | DEFINER | CHARACTER_SET_CLIENT | COLLATION_CONNECTION | DATABASE_COLLATION | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
extract_schema_from_file_name | def | sys | extract_schema_from_file_name | FUNCTION | varchar | 64 | 256 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | varchar(64) | SQL |
|
NULL | SQL | SQL | YES | NO SQL | NULL | INVOKER | 2019-10-30 15:09:30 | 2019-10-30 15:09:30 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... | Description ----------- Takes a raw file path, a... |
mysql.sys@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | |
extract_table_from_file_name | def | sys | extract_table_from_file_name | FUNCTION | varchar | 64 | 256 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | varchar(64) | SQL |
|
NULL | SQL | SQL | YES | NO SQL | NULL | INVOKER | 2019-10-30 15:09:30 | 2019-10-30 15:09:30 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... | Description ----------- Takes a raw file path, a... |
mysql.sys@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | |
format_bytes | def | sys | format_bytes | FUNCTION | text | 65535 | 65535 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | text | SQL |
|
NULL | SQL | SQL | YES | NO SQL | NULL | INVOKER | 2019-10-30 15:09:30 | 2019-10-30 15:09:30 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... | Description ----------- Takes a raw bytes value,... |
mysql.sys@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | |
format_path | def | sys | format_path | FUNCTION | varchar | 512 | 2048 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | varchar(512) | SQL |
|
NULL | SQL | SQL | YES | NO SQL | NULL | INVOKER | 2019-10-30 15:09:30 | 2019-10-30 15:09:30 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... | Description ----------- Takes a raw path value, ... |
mysql.sys@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | |
format_statement | def | sys | format_statement | FUNCTION | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | longtext | SQL |
|
NULL | SQL | SQL | YES | NO SQL | NULL | INVOKER | 2019-10-30 15:09:30 | 2019-10-30 15:09:30 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... | Description ----------- Formats a normalized sta... |
mysql.sys@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | |
format_time | def | sys | format_time | FUNCTION | text | 65535 | 65535 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | text | SQL |
|
NULL | SQL | SQL | YES | NO SQL | NULL | INVOKER | 2019-10-30 15:09:30 | 2019-10-30 15:09:30 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... | Description ----------- Takes a raw picoseconds ... |
mysql.sys@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | |
list_add | def | sys | list_add | FUNCTION | text | 65535 | 65535 | NULL | NULL | NULL |