Re: Question on default database for stored functions

2008-12-26 Thread Peter Brawley
rapez...@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 i

RE: Question on default database for stored functions

2008-12-26 Thread Jerry Schwartz
>-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 > >Acco

Question on default database for stored functions

2008-12-25 Thread Vikram Vaswani
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 e