Use the mysql. proc table to obtain basic data information

No details: MySQLmysqlmysqlmysqlDELIMITERmysqlmysqlCREATEFUNCTIONmyFunction (item_sumDECIMAL ))

No details about 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> 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>