摘要: drop procedure if exists teach.num_from_student; create procedure teach.student_a(in dept_name varchar(20),out count_num int) begin select count(*) into count_num from t_student where stu_dept=dept_n... 阅读全文
posted @ 2016-04-18 10:43 尘梦 阅读(132) 评论(0) 推荐(0) 编辑
摘要: DROP PROCEDURE IF EXISTS teach.sp_Score_Level; CREATE PROCEDURE `sp`() BEGIN declare cur_stu_id int; declare cur_course_id int; declare cur_grade varchar(10); DECLARE done INT DEFAULT 0; d... 阅读全文
posted @ 2016-04-18 09:48 尘梦 阅读(180) 评论(0) 推荐(0) 编辑