- 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_SQL
- is_deterministic: NO
- security_type: DEFINER
- param_list: item_sum DECIMAL(10,2)
- returns: decimal(10,1)
- body: BEGIN
- RETURN 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>
- --该片段来自于http://www.codesnippet.cn/detail/12112012258.html
来源: http://www.codesnippet.cn/detail/12112012258.html