1. 创建存储过程,根据员工编号判断此员工到目前的工作年限,如果工龄已经大于38年,将其调用到和King员工同一个部门
思路
- 找到工龄大于38年的员工编号, 集合 A
- 找到King员工的编号
- 遍历 集合A 将结合A的编号设置为 员工编号、
实现
select empno from t_employee WHERE t_employee.ename = 'King';
select hiredate, CURRENT_DATE, YEAR(CURRENT_DATE)- YEAR(hiredate) from t_employee;
select hiredate, CURRENT_DATE, YEAR(CURRENT_DATE)- YEAR(hiredate) from t_employee where (YEAR(CURRENT_DATE)- YEAR(hiredate) )
>36;
select empno, hiredate, CURRENT_DATE, YEAR(CURRENT_DATE)- YEAR(hiredate) from t_employee where (YEAR(CURRENT_DATE)- YEAR(hiredate) )
>36;
drop procedure if exists pro_search;
create procedure
pro_search()
BEGIN
DECLARE