how to check if a stored procedure has been called from another stored procedure in mysql? So here I am using MysqlYog / Phpmyadmin for my database management.
Now I have lots of store procedure written and now I want to delete a store procedure as it don't have any direct use but I can not because I don't know if this procedure is being called from another procedure or not.
So how can i check that.
FYI : 
DB- MYSQL
Scripting Language : Php
ok .I found it with select query 

SELECT COUNT(1)
FROM INFORMATION_SCHEMA.ROUTINES 
WHERE ROUTINE_DEFINITION LIKE '%procedureName%' 
AND ROUTINE_TYPE='PROCEDURE' AND ROUTINE_SCHEMA = 'dbName';