MySQL Tutorial/Procedure Function/NUMERIC

NUMERIC(8,2) DEFAULT 9.95

   <source lang="sql">

mysql> mysql> delimiter $$ mysql> mysql> CREATE PROCEDURE myProc()

   -> BEGIN
   ->      DECLARE l_numeric   NUMERIC(8,2) DEFAULT 9.95;
   ->
   ->     select l_numeric;
   -> END$$

Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> mysql> call myProc(); +-----------+ | l_numeric | +-----------+ | 9.95 | +-----------+ 1 row in set (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> mysql> drop procedure myProc; Query OK, 0 rows affected (0.00 sec) mysql> mysql></source>

Variable type NUMERIC(8,2)

   <source lang="sql">

mysql> mysql> delimiter $$ mysql> CREATE PROCEDURE myProc()

   -> BEGIN
   ->     DECLARE my_currency    NUMERIC(8,2);  /* Number with 2 decimals*/
   ->
   ->     set my_currency = 123123.123;
   ->
   ->     select "my_currency="+my_currency;
   -> END$$

Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> mysql> call myProc(); +----------------------------+ | "my_currency="+my_currency | +----------------------------+ | 123123.12 | +----------------------------+ 1 row in set (0.00 sec) Query OK, 0 rows affected, 2 warnings (0.00 sec) mysql> mysql> drop procedure myProc; Query OK, 0 rows affected (0.00 sec) mysql> mysql></source>