Re: How do I get a list of all defined UDF's known to the system?

[Wagner Bianchi]

mysql> DELIMITER //
mysql> CREATE PROCEDURE test.sp1() SELECT 'Hello!' AS Msg;
    -> //
Query OK, 0 rows affected (0,00 sec)

mysql> SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES;
    -> //
+--------------+
| ROUTINE_NAME |
+--------------+
| sp1          |
+--------------+
1 row in set (0,00 sec)


Wagner Bianchi


2010/2/8 Robert Gilland <robert.gilland@stripped>

>  Hi,
>
>
>
> Trying this SQL (SELECT * FROM INFORMATON_SCHEMA.ROUTINES)
>
> On MySQL 7.0 (C:\Program Files\MySQL\MySQL Server 7.0\bin)
>
>
>
> I get the following error:
>
>
>
> Table “information_schema.routines” does not exist.
>
>
>
> Kind Regards,
>
>
>
> Robert.
>
>
>
>
>
>
>
> *From:* Wagner Bianchi [mailto:wagnerbianchijr@stripped]
> *Sent:* Monday, 8 February 2010 11:11 PM
> *To:* Robert Gilland
> *Subject:* Re: How do I get a list of all defined UDF's known to the
> system?
>
>
>
> SELECT * FROM INFORMATON_SCHEMA.ROUTINES;
>
> Aply filter over this query.
>
> --
> Wagner Bianchi
>
>  2010/2/8 Sir Wally Lewis <robert.gilland@stripped>
>
> Thanks
>
> "Suresh Kuna" <sureshkumarilu@stripped> wrote in message
> news:23397e991002072211l95b2063i40876e0ada93e8b9@ style="color:#666">stripped...
>
> > Hi Robert,
> >
> > We can see the functions by using the below command
> >
> > Show function status ;
> >
> > --
> > Suresh Kuna
> > MySQL DBA
> >
> > On Mon, Feb 8, 2010 at 10:37 AM, Sir Wally Lewis
> > <robert.gilland@stripped
> >> wrote:
> >
> >> How do I get a list of all defined UDF's known to the system?
> >>
> >>
> >>
> >> Kind Regards,
> >>
> >>
> >>
> >> Robert.
> >>
> >>
> >>
> >> --
> >> MySQL General Mailing List
> >> For list archives: http://lists.mysql.com/mysql
> >> To unsubscribe:
> >> http://lists.mysql.com/mysql?unsub=1
> >>
> >>
> >
>
>
>   --
>
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
>
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
>
> --
> This message has been scanned for viruses and
> dangerous content by *MailScanner* <http://www.mailscanner.info/>, and is
> believed to be clean.
>
> --
> This message has been scanned for viruses and
> dangerous content by *MailScanner* <http://www.mailscanner.info/>, and is
> believed to be clean.
>