From: Martijn Tonies
Date: February 4 2004 2:56pm
Subject: Re: MySQL 5 Stored Procedures are server wide?
List-Archive: http://lists.mysql.com/mysql/158944
Message-Id: <006001c3eb2f$1aa77c00$0e02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi,

> > When creating a stored procedure, what must I do to
> > create a procedure/function in a specific database?
> >
> > I created a function "hello" like in the example, but
> > afterwards, I cannot create it from another database
> > connection.
>
> Currently you can't create SP in the particular database.
>
> >
> > The column "db" stays NULL in table "procs".
> >
> > Any idea?
>
> Column 'db' in the table 'proc' isn't used yet. It's for future use.

Thank you for your answer. Can I expect procedures/functions
to be database specific in the future? Or will they stay server-wide?
IMO, they should be db specific :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com