mysql>mysql> DELIMITER //mysql>mysql> CREATE FUNCTION myFunction (cost DECIMAL(10,2)) RETURNS DECIMAL(10,2) -> BEGIN -> -> DECLARE shipping_cost DECIMAL(10,2); -> -> SET shipping_cost = 0; -> IF cost < 25.00 THEN -> SET shipping_cost = 10.00; -> ELSEIF cost < 100.00 THEN -> SET shipping_cost = 20.00; -> ELSEIF cost < 200.00 THEN -> SET shipping_cost = 30.00; -> -> ELSE -> SET shipping_cost = 40.00; -> END IF; -> -> RETURN shipping_cost; -> END -> //Query OK, 0 rows affected (0.00 sec)mysql> DELIMITER ;mysql>mysql> select myFunction(123.123);+---------------------+| myFunction(123.123) |+---------------------+| 30.00 |+---------------------+1 row in set, 1 warning (0.02 sec)mysql>mysql> drop function myFunction;Query OK, 0 rows affected (0.00 sec)
Name (required)
email (will not be published) (required)
Website