emp_name
| Documentation | Employees (MySQL database) |
| Name | emp_name |
Returns the employee name of a given employee id
Input/Output
| Mode | Name | Data type | Description | |
|---|---|---|---|---|
| 1 | OUT | Returns | varchar(32) | Returns the employee name of a given employee id |
| Returns the employee name of a given employee id | ||||
| 2 | IN | employee_id | int(10, 0) | Employee identification number |
| Employee identification number | ||||
Script
begin return ( select concat(first_name, ' ', last_name) as name from employees where emp_no = employee_id ); end |
Exported: 2018-11-09 14:32, Last imported: 2018-08-06 09:21