mysql> DELIMITER //
mysql> CREATE FUNCTION CalculatePrice( Preis REAL , Marge REAL ) RETURNS REAL
-> BEGIN
-> DECLARE CalculatedPrice REAL;
-> SET CalculatedPrice = ROUND( (Preis + Marge)*1.076*20,0)/20;
-> RETURN CalculatedPrice;
-> END
-> //
Query OK, 0 rows affected (0.09 sec)
mysql> DELIMITER ;
mysql> SHOW CREATE FUNCTION CalculatePrice;
+----------------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Function | sql_mode | Create Function |
+----------------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| CalculatePrice | | CREATE DEFINER=`root`@`localhost` FUNCTION `CalculatePrice`( Preis REAL , Marge REAL ) RETURNS double
BEGIN
DECLARE CalculatedPrice REAL;
SET CalculatedPrice = ROUND( (Preis + Marge)*1.076*20,0)/20;
RETURN CalculatedPrice;
END |
+----------------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select CalculatePrice(100,20);
+------------------------+
| CalculatePrice(100,20) |
+------------------------+
| 129.1 |
+------------------------+
1 row in set (0.02 sec)
mysql>