利用mysql.proc表来获取基础数据信息

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> 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>