delimiter $$
create PROCEDURE proc_manager_pro()
READS SQL DATA
begin
SELECT count(pro_name) FROM t_project;
end
$$delimiter;
call proc_manager_pro;
DELEMITER //
CREATE TRIGGER INSERT_trigger() after INSERT on t_manager
for EACH row
BEGIN
INSERT INTO t_log VALUES(1,"项目经理又接项目啦")
END//
DELEMITER ;;