MySQL 常用语句

查询某个数据表被哪些存储过程用到的语句：

SELECT  *FROM mysql.proc
WHERE DB = 'DBNAME' AND `Type` = 'PROCEDURE' AND body LIKE '%TABLENAME%';