mysql>mysql> DELIMITER //mysql>mysql> CREATE FUNCTION myFunction (rush_ship INT(10)) RETURNS DECIMAL(10,2) -> BEGIN -> -> DECLARE rush_shipping_cost DECIMAL(10,2); -> -> CASE rush_ship -> WHEN 1 THEN -> SET rush_shipping_cost = 20.00; -> WHEN 2 THEN -> SET rush_shipping_cost = 15.00; -> WHEN 3 THEN -> SET rush_shipping_cost = 10.00; -> ELSE -> SET rush_shipping_cost = 0.00; -> END CASE; -> -> RETURN rush_shipping_cost; -> -> END -> //Query OK, 0 rows affected (0.00 sec)mysql>mysql> CREATE FUNCTION myFunction1 (item_sum DECIMAL(10,2)) -> RETURNS DECIMAL(10,1) -> BEGIN -> -> RETURN myFunction(1); -> -> END -> //Query OK, 0 rows affected (0.00 sec)mysql>mysql> DELIMITER ;mysql>mysql>mysql> select myFunction1(1);+----------------+| myFunction1(1) |+----------------+| 20.0 |+----------------+1 row in set (0.00 sec)mysql>mysql>mysql> drop function myFunction1;Query OK, 0 rows affected (0.00 sec)mysql> drop function myFunction;Query OK, 0 rows affected (0.00 sec)mysql>
Name (required)
email (will not be published) (required)
Website
