Mega Code Archive

 

Categories / MySQL / Command Mysql

 

Determining Existing SPs

mysql> mysql> mysql> SHOW FUNCTION STATUS; +------+-----------+----------+----------------+---------------------+---------------------+---------------+---------+-- --------------------+----------------------+--------------------+ | Db   | Name      | Type     | Definer        | Modified            | Created             | Security_type | Comment | c haracter_set_client | collation_connection | Database Collation | +------+-----------+----------+----------------+---------------------+---------------------+---------------+---------+-- --------------------+----------------------+--------------------+ | test | factorial | FUNCTION | root@localhost | 2011-10-03 08:57:33 | 2011-10-03 08:57:33 | DEFINER       |         | l atin1               | latin1_swedish_ci    | latin1_swedish_ci  | | test | half      | FUNCTION | root@localhost | 2011-10-03 08:57:34 | 2011-10-03 08:57:34 | DEFINER       |         | l atin1               | latin1_swedish_ci    | latin1_swedish_ci  | | test | test      | FUNCTION | root@localhost | 2011-10-03 08:57:33 | 2011-10-03 08:57:33 | DEFINER       |         | l atin1               | latin1_swedish_ci    | latin1_swedish_ci  | +------+-----------+----------+----------------+---------------------+---------------------+---------------+---------+-- --------------------+----------------------+--------------------+ 3 rows in set (0.00 sec) mysql>