控制台
当前所选内容没有包含唯一字段。单元格编辑、复选框、编辑、复制和删除无法正常使用。
正在显示第 0 - 5 行 (共 6 行, 查询花费 0.0026 秒。)
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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| film_in_stock | def | sakila | film_in_stock | PROCEDURE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SQL | |
NULL | NULL | SQL | NO | READS SQL DATA | NULL | DEFINER | 2023-12-13 12:33:58 | 2023-12-13 12:33:58 | NO_AUTO_VALUE_ON_ZERO | root@localhost | utf8mb4 | utf8mb4_general_ci | latin1_swedish_ci | |||
| film_not_in_stock | def | sakila | film_not_in_stock | PROCEDURE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SQL | |
NULL | NULL | SQL | NO | READS SQL DATA | NULL | DEFINER | 2023-12-13 12:33:58 | 2023-12-13 12:33:58 | NO_AUTO_VALUE_ON_ZERO | root@localhost | utf8mb4 | utf8mb4_general_ci | latin1_swedish_ci | |||
| get_customer_balance | def | sakila | get_customer_balance | FUNCTION | decimal | NULL | NULL | 5 | 2 | NULL | NULL | NULL | decimal(5,2) | SQL | |
NULL | NULL | SQL | YES | READS SQL DATA | NULL | DEFINER | 2023-12-13 12:33:58 | 2023-12-13 12:33:58 | NO_AUTO_VALUE_ON_ZERO | root@localhost | utf8mb4 | utf8mb4_general_ci | latin1_swedish_ci | ||
| inventory_held_by_customer | def | sakila | inventory_held_by_customer | FUNCTION | int | NULL | NULL | 10 | 0 | NULL | NULL | NULL | int(11) | SQL | |
NULL | NULL | SQL | NO | READS SQL DATA | NULL | DEFINER | 2023-12-13 12:33:58 | 2023-12-13 12:33:58 | NO_AUTO_VALUE_ON_ZERO | root@localhost | utf8mb4 | utf8mb4_general_ci | latin1_swedish_ci | ||
| inventory_in_stock | def | sakila | inventory_in_stock | FUNCTION | tinyint | NULL | NULL | 3 | 0 | NULL | NULL | NULL | tinyint(1) | SQL | |
NULL | NULL | SQL | NO | READS SQL DATA | NULL | DEFINER | 2023-12-13 12:33:58 | 2023-12-13 12:33:58 | NO_AUTO_VALUE_ON_ZERO | root@localhost | utf8mb4 | utf8mb4_general_ci | latin1_swedish_ci | ||
| rewards_report | def | sakila | rewards_report | PROCEDURE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SQL | |
NULL | NULL | SQL | NO | READS SQL DATA | NULL | DEFINER | 2023-12-13 12:33:58 | 2023-12-13 12:33:58 | NO_AUTO_VALUE_ON_ZERO | Provides a customizable report on best customers | root@localhost | utf8mb4 | utf8mb4_general_ci | latin1_swedish_ci |
| 过滤行: |