统计msyql存储过程，视图，触发器数量

作用：统计mysql存储过程，视图，触发器数量。

 

select 'routines',count(*) from information_schema.routines \

union \

select 'views',count(*) from information_schema.views \

union \

select 'triggers',count(*) from information_schema.triggers;