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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
rewards_report | def | sakila | rewards_report | PROCEDURE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SQL |
|
NULL | SQL | SQL | NO | READS SQL DATA | NULL | DEFINER | 2019-10-30 15:22:08 | 2019-10-30 15:22:08 | STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... | Provides a customizable report on best customers | root@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | ||
get_customer_balance | def | sakila | get_customer_balance | FUNCTION | decimal | NULL | NULL | 5 | 2 | NULL | NULL | NULL | decimal(5,2) | SQL |
|
NULL | SQL | SQL | YES | READS SQL DATA | NULL | DEFINER | 2019-10-30 15:22:08 | 2019-10-30 15:22:08 | STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... | root@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | ||
film_in_stock | def | sakila | film_in_stock | PROCEDURE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SQL |
|
NULL | SQL | SQL | NO | READS SQL DATA | NULL | DEFINER | 2019-10-30 15:22:08 | 2019-10-30 15:22:08 | STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... | root@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | |||
film_not_in_stock | def | sakila | film_not_in_stock | PROCEDURE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SQL |
|
NULL | SQL | SQL | NO | READS SQL DATA | NULL | DEFINER | 2019-10-30 15:22:08 | 2019-10-30 15:22:08 | STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... | root@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | |||
inventory_held_by_customer | def | sakila | inventory_held_by_customer | FUNCTION | int | NULL | NULL | 10 | 0 | NULL | NULL | NULL | int(11) | SQL |
|
NULL | SQL | SQL | NO | READS SQL DATA | NULL | DEFINER | 2019-10-30 15:22:08 | 2019-10-30 15:22:08 | STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... | root@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | ||
inventory_in_stock | def | sakila | inventory_in_stock | FUNCTION | tinyint | NULL | NULL | 3 | 0 | NULL | NULL | NULL | tinyint(1) | SQL |
|
NULL | SQL | SQL | NO | READS SQL DATA | NULL | DEFINER | 2019-10-30 15:22:08 | 2019-10-30 15:22:08 | STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... | root@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci |
|