Name

SHOW FUNCTION STATUS

Synopsis

SHOW FUNCTION STATUS [LIKE 'pattern'|WHERE expression]

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.

Start your free trial