mysql mysqlmysqlmysql delimiter //mysqlmysql create function myfunction (item_sum decimal(10,2)) - returns decimal(10,1) - begin - - - return round(item_sum,1); - - end - //query ok, 0 rows affected (0.00 sec)mysql delimiter ;mys
相关mysql视频教程推荐：《mysql教程》
mysql>mysql>mysql> delimiter //mysql>mysql> create function myfunction (item_sum decimal(10,2)) -> returns decimal(10,1) -> begin -> -> -> return round(item_sum,1); -> -> end -> //query ok, 0 rows affected (0.00 sec)mysql> delimiter ;mysql>mysql> select myfunction(123.12);+--------------------+| myfunction(123.12) |+--------------------+| 123.1 |+--------------------+1 row in set (0.00 sec)mysql>mysql>mysql>mysql> select * from mysql.proc where name = 'myfunction'\g*************************** 1. row *************************** db: test name: myfunction type: function specific_name: myfunction language: sql sql_data_access: contains_sqlis_deterministic: no security_type: definer param_list: item_sum decimal(10,2) returns: decimal(10,1) body: beginreturn round(item_sum,1);end definer: root@localhost created: 2007-07-23 18:58:39 modified: 2007-07-23 18:58:39 sql_mode: comment:1 row in set (0.00 sec)mysql>mysql> drop function myfunction;query ok, 0 rows affected (0.00 sec)mysql>mysql>