mysql>
mysql> delimiter $$
mysql> CREATE PROCEDURE myProc(normal_price NUMERIC(8,2),OUT discount_price NUMERIC(8,2))
-> NO SQL
-> BEGIN
-> IF (normal_price>500) THEN
-> SET discount_price=normal_price*.8;
-> ELSEIF (normal_price>100) THEN
-> SET discount_price=normal_price*.9;
->
-> ELSE
-> SET discount_price=normal_price;
-> END IF;
-> select discount_price;
-> END$$
Query OK, 0 rows affected (0.00 sec)
mysql> delimiter ;
mysql>
mysql> set @p = 600;
Query OK, 0 rows affected (0.00 sec)
mysql> set @dp = 0;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> call myProc(@p, @dp);
+----------------+
| discount_price |
+----------------+
| 480.00 |
+----------------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> select @dp;
+--------+
| @dp |
+--------+
| 480.00 |
+--------+
1 row in set (0.00 sec)
mysql> drop procedure myProc;
Query OK, 0 rows affected (0.00 sec)
mysql>