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.gill...@basx.com.au>
> 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:wagnerbianch...@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 <robert.gill...@basx.com.au>
>
> Thanks
>
> "Suresh Kuna" <sureshkumar...@gmail.com> wrote in message
> news:23397e991002072211l95b2063i40876e0ada93e...@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
> > <robert.gill...@basx.com.au
> >> 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=sureshkumar...@gmail.com
> >>
> >>
> >
>
>
> --
>
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
>
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=wagnerbianch...@gmail.com
>
>
>
> --
> 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.
>
