select get_area(11);
ERROR 1305 (42000): FUNCTION test2.get_area does not exist
Can someone tell me what I'm doing wrong? Thanks.
SELECT dbWhereFunctionWasCreated.get_area(11);
PB
-----
Jerry Schwartz wrote:
-----Original Message-----
From: blue.trapez...@gmail.com [mailto:blue.trapez...@gmail.com] On
Behalf Of Vikram Vaswani
Sent: Thursday, December 25, 2008 5:47 AM
To: mysql@lists.mysql.com
Subject: Question on default database for stored functions
Hi
According to the MySQL manual, "By default, a routine is associated with
the default database.When the routine is invoked, an implicit USE
db_name is performed (and undone when the routine terminates)"
However, when I tried accessing a stored routine from another database,
I received an error. Output below:
mysql> USE test
[JS] Stupid question, but do you have a semicolon at the end of the USE
statement?
mysql> DELIMITER //
mysql> CREATE FUNCTION get_area(radius INT)
-> RETURNS FLOAT
-> BEGIN
-> RETURN PI() * radius * radius;
-> END
-> //
Query OK, 0 rows affected (0.13 sec)
mysql> DELIMITER ;
mysql> USE test2
Database changed
mysql> select get_area(11);
ERROR 1305 (42000): FUNCTION test2.get_area does not exist
Can someone tell me what I'm doing wrong? Thanks.
Vikram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=jschwa...@the-
infoshop.com
------------------------------------------------------------------------
Internal Virus Database is out of date.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.9.19/1853 - Release Date: 12/17/2008 8:31 AM