Name
SHOW FUNCTION STATUS
Synopsis
SHOW FUNCTION STATUS [LIKE 'pattern
'|WHEREexpression
]
This statement displays information on user-defined
functions. The LIKE
or WHERE
clauses can be used to list functions based on a particular naming
pattern. With the WHERE
clause, you can use the
names of fields in the results to create an expression that sets a
condition determining the results returned. Here is an example using
this statement:
SHOW FUNCTION STATUS WHERE Name='date_reformatted' \G *************************** 1. row *************************** Db: college Name: date_reformatted Type: FUNCTION Definer: root@localhost Modified: 2007-11-27 11:55:00 Created: 2007-11-27 11:47:37 Security_type: INVOKER Comment: Converts a string date like 'Dec. 7, 2007' to standard format.
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.