第一次用mysql实现一个简单的存储过程,返回查询员工的工资等级。
工资<1000,等级为D;
1000<=工资<2000,等级为C;
2000<=工资<3000,等级为B;
3000<=工资<5000,等级为A;
5000<=工资,等级为S;
首先准备一张员工信息表(emp),数据如下。
INSERT INTO `emp` VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17', '800', null, '20');
INSERT INTO `emp` VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20', '1600', '300', '30');
INSERT INTO `emp` VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22', '1250', '500', '30');
INSERT INTO `emp` VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02', '2975', null, '20');
INSERT IN