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

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=gcdmg-mysql-2@m.gmane.org

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

--00504502ad20196414047f10ad2d
Content-Type: text/plain; charset=ISO-8859-1

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 > 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=sureshkumarilu@gmail.com
>
>

--00504502ad20196414047f10ad2d--

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

Thanks

"Suresh Kuna" wrote in message
news:23397e991002072211l95b2063i40876e0ada93e8b9@mail.gmail. com...
> 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
> >> 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=sureshkumarilu@gmail.com
>>
>>
>



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

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

--0016e6dab150d12a9d047f1ea383
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

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

> 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 =93information_schema.routines=94 does not exist.
>
>
>
> Kind Regards,
>
>
>
> Robert.
>
>
>
>
>
>
>
> *From:* Wagner Bianchi [mailto:wagnerbianchijr@gmail.com]
> *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
>
> Thanks
>
> "Suresh Kuna" wrote in message
> news:23397e991002072211l95b2063i40876e0ada93e8b9@mail.gmail. com...
>
> > 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
> > > >> 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=3Dsureshkumarilu@gmail.co m
> >>
> >>
> >
>
>
> --
>
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
>
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=3Dwagnerbianchijr@gmail.c om
>
>
>
> --
> This message has been scanned for viruses and
> dangerous content by *MailScanner* , and is
> believed to be clean.
>
> --
> This message has been scanned for viruses and
> dangerous content by *MailScanner* , and is
> believed to be clean.
>

--0016e6dab150d12a9d047f1ea383--