how to check if a stored procedure has been called from another stored procedure in mysql?
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';