From: Martijn Tonies
Date: February 4 2004 8:42am
Subject: MySQL 5 Stored Procedures are server wide?
List-Archive: http://lists.mysql.com/mysql/158929
Message-Id: <025501c3eafa$c7f435e0$0e02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi all,

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.

The column "db" stays NULL in table "procs".

Any idea?


With regards,

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