[GastForen

  • Suche
  • Hilfe
  • Lesezeichen
  • Benutzerliste
Forenindex -- Lesezeichen

1 Lesezeichen für procedure

Stored Procedure Problem
hi bline,

probier mal das:

Code
 
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>

...
oesi50
27. Nov 2008, 17:33