MySQL中关于存储过程和函数的操作

-- 查看一个数据库中的所有存储过程合函数
-- Is there a way to view all stored procedures and stored functions in a given database
SELECT ROUTINE_TYPE, ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA='trd';
-- The body of a stored routine can be viewed using under ways 查看或删除函数 存储过程 
SHOW CREATE FUNCTION fun_addnum;
DROP FUNCTION IF EXISTS fun_addnum;
SHOW CREATE PROCEDURE citycount;
DROP PROCEDURE IF EXISTS citycount;