mysql有哪些表,存储过程,函数,触发器,视图,事件

查看有哪些存储过程,函数,触发器

select db,`name` from mysql.proc where `type` = 'PROCEDURE'; //存储过程
select db,`name` from mysql.proc where `type` = 'FUNCTION'; //函数
SELECT TRIGGER_SCHEMA,TRIGGER_NAME FROM INFORMATION_SCHEMA.triggers; //触发器
SELECT TABLE_SCHEMA,TABLE_NAME from information_schema.VIEWS; //视图
SELECT count(0) from information_schema.TABLES; //表
SELECT EVENT_SCHEMA,EVENT_NAME FROM INFORMATION_SCHEMA.events; //事件

 

给过程执行权限
GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON `school`.* TO 'tmapps'@'10.%';
GRANT SELECT ON `mysql`.`proc` TO 'tmapps'@'10.%' ;

 

 

查看存储过程或函数的创建代码

show create procedure proc_name;
show create function func_name;

查看触发器

语法：SHOW TRIGGERS [FROM db_name] [LIKE expr]
实例：SHOW TRIGGERS\G //触发器