Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Statements in Alphabetical Order > SHOW FUNCTION STATUS

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.

  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint