Stored Procedure and the procs.db column

2004-01-27 Thread Martijn Tonies
Hi all, I'm investigating the Stored Procedures in MySQL 5, and I'm wondering... I've been looking through the "procs" table in "mysql" - what does column "db" do? It stays "null" when I defined a procedure. And how can you get a list of available procedures? SHOW PROCEDURE doesn't seem to work?

Stored Procedure and the procs.db column

2004-01-23 Thread Martijn Tonies
Hi all, I'm investigating the Stored Procedures in MySQL 5, and I'm wondering... I've been looking through the "procs" table in "mysql" - what does column "db" do? It stays "null" when I defined a procedure. And how can you get a list of available procedures? SHOW PROCEDURE doesn't seem to work?