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;