employees_usage
Documentation | Employees (MySQL database) |
Name | employees_usage |
Returns information about procedures/functions.
Input/Output
Mode | Name | Data type | Description | |
---|---|---|---|---|
1 | OUT | Returns | text | Return information about procedures/functions. |
Return information about procedures/functions. |
Script
BEGIN RETURN ' == USAGE == ==================== PROCEDURE show_departments() shows the departments with the manager and number of employees per department FUNCTION current_manager (dept_id) Shows who is the manager of a given departmennt FUNCTION emp_name (emp_id) Shows name and surname of a given employee FUNCTION emp_dept_id (emp_id) Shows the current department of given employee '; END |
Exported: 2018-11-09 14:32, Last imported: 2018-08-06 09:21