CODEWITHSUNDEEP
mysqlstored-procedures
endyourif
endyourif

Reputation: 2202

Determine the database name inside of stored procedure

I've created a stored procedure in Mysql and I was wondering if there is a command that I can get and store the name of the database that this stored procedure lives in?

Upvotes: 1

Views: 882

Answers (2)

user3648976
user3648976

Reputation: 1

Your Question is wrong?..Your actual question is you have created a stored procedure inside the databases...not how to retrieve the procedure inside the database? Ans: To know the created procedure:

mysql:\> show procedure status;  //to know the procedure name..sam4 function show function staus;
mysql:\> show use create procedure emptab.test1 //emptab is database name,test1 is the procedure..

Upvotes: -1

Alain Collins
Alain Collins

Reputation: 16362

How about DATABASE() ?

(This text is just filler)

Upvotes: 2

Related Questions