mysql>
mysql> delimiter $$
mysql>
mysql> CREATE PROCEDURE myProc(customer_status VARCHAR(10))
-> BEGIN
->
-> CASE customer_status
-> WHEN 'PLATINUM' THEN
-> select 'PLATINUM';
->
-> WHEN 'GOLD' THEN
-> select 'GOLD';
->
-> WHEN 'SILVER' THEN
-> select 'SILVER';
->
-> WHEN 'BRONZE' THEN
-> select 'BRONZE';
-> END CASE;
-> END$$
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> delimiter ;
mysql> call myProc('BRONZE');
+--------+
| BRONZE |
+--------+
| BRONZE |
+--------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> call myProc('GOLD');
+------+
| GOLD |
+------+
| GOLD |
+------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> drop procedure myProc;
Query OK, 0 rows affected (0.00 sec)