mysql存储过程

#MYSQL的存储过程
# 创建一个简单的存储过程
DELIMITER $$
CREATE PROCEDURE seleTeuById()
BEGIN 
 SELECT * FROM students WHERE id = 1;
 
 END;
 $$
 DELIMITER;
# 调用存储过程
CALL  seleTeuById();
 
 
#存储过程的变量
DELIMITER $$
CREATE PROCEDURE stuFinal()
BEGIN 
-- 创建一个变量默认为空''
DECLARE stu_name VARCHAR(32) DEFAULT '';
-- 跟变量设置值
SET stu_name = '哈哈哈';
-- 查出name 的值赋 给 stu_name
SELECT `name` INTO stu_name FROM students WHERE id = 4;
 
-- 把结果输出出来
SELECT stu_name;
END;
$$
DELIMITER;
-- 调用存储过程 (一直失败不知道怎么回事)
CALL stuFinal();
 
 
# 多个语句块
 
DELIMITER $$
CREATE PROCEDURE stuAndTetRegister()
BEGIN
  BEGIN 
     DECLARE stu_sum INT DEFAULT 0;
     DECLARE tea_sum INT DEFAULT 0;
     SELECT COUNT(*) INTO stu_sum FROM `students`  ;
     SELECT COUNT(*) INTO tea_sum FROM `teacher`;
     SELECT stu_sum,tea_sum;
  END ;
 
  BEGIN 
     DECLARE max_reg TIMESTAMP;
     DECLARE min_reg TIMESTAMP;
     SELECT MAX(create_time),MIN(create_time) INTO max_reg, min_reg FROM `teacher`;
     SELECT max_reg,min_reg 
  END ;
END ;
 
$$
DELIMITER;