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)
Name (required)
email (will not be published) (required)
Website