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.
