CREATE PROCEDURE p_student_select()
BEGIN 
SELECT * FROM student;
END

CALL p_student_select()

# out其實(shí)就是cpp里的引用變量，in就是值傳遞
CREATE PROCEDURE p_count(OUT count int)
BEGIN
SELECT COUNT(*) into count FROM student;
END

set @num = 10;	# 定義變量
CALL p_count(@num);		#我的數(shù)據(jù)有11條
SELECT @num as num;		#這里的num已經(jīng)是11了

--這個(gè)就是一個(gè)調(diào)用參數(shù)的函數(shù)
CREATE PROCEDURE p_studnt_selectById(in id int)
BEGIN
SELECT * FROM student WHERE studentNo = id;
END

CALL p_studnt_selectById(4)

#兩個(gè)參數(shù)是一樣的用法
CREATE PROCEDURE p_result_test(out num int, in id int)
BEGIN
SELECT COUNT(*) INTO num FROM result WHERE studentNo = id;
END

set @num = 0;
CALL p_result_test(@num, 3);
SELECT @num as num

# declare的作用是用來(lái)定義變量

CREATE PROCEDURE p5()
BEGIN
DECLARE studentName VARCHAR(10);	#創(chuàng)建了一個(gè)變量
set @studentName = 'HELLO';		#給變量賦值
END

CALL p5();
SELECT @studentName
-- 說(shuō)明了declare定義的變量可以在外部直接調(diào)用

#if語(yǔ)句沒(méi)啥說(shuō)的，代碼直接能看懂
CREATE PROCEDURE p6(in id int)
BEGIN
IF(id = 0) THEN
	SELECT * FROM student;
ELSE
	SELECT * FROM teacher;
END IF;
END

#看代碼...
CREATE PROCEDURE p7(in tab VARCHAR(10))
BEGIN
CASE tab
	WHEN 'student' THEN
		SELECT * FROM student;
	WHEN 'teacher' THEN
		SELECT * FROM teacher;
END CASE;
END

CREATE PROCEDURE p9(IN id INT)
BEGIN
addloop: LOOP
	set id = id + 1;
	SELECT id;
	IF id > 10 THEN
		LEAVE addloop;
	ELSE
		SELECT * FROM student; 
	END IF; 
END LOOP addloop;

END

CREATE PROCEDURE p10(in count int)
BEGIN
REPEAT
	set count = count + 1;
	SELECT count;
UNTIL count > 10 END REPEAT;	#count >10跳出

END

CREATE PROCEDURE p11(in num int)
BEGIN
while num < 10 DO
	SELECT num;
	SET  num = num + 1; 
END WHILE;
END