mysql> mysql> mysql> mysql> SHOW CREATE FUNCTION test.myFunctionG *************************** 1. row *************************** Function: myFunction sql_mode: Create Function: CREATE DEFINER=`root`@`localhost` FUNCTION `myFunction`(item_sum DECIMAL(10,2)) RETURNS decimal(10,1) BEGIN RETURN ROUND(item_sum,1); END 1 row in set (0.00 sec)
mysql> mysql> drop function myFunction; Query OK, 0 rows affected (0.00 sec)
mysql> mysql>
Related Scripts with Example Source Code in same category :