随笔分类 -  Sql-存储过程

摘要：delimiter // create procedure p7(inout a int,inout b int) begin set a=a*2; set b=b*2; end// set @a=3; set @b=5; call p7(@a,@b) select @a,@b 阅读全文

摘要：DELIMITER // CREATE PROCEDURE myproc(OUT s int) BEGIN SELECT COUNT(*) INTO s FROM students; END; // DELIMITER ; call myproc(@y) 阅读全文

摘要：CREATE PROCEDURE chegji(IN chji INT)BEGINIF chji>=90 THEN SELECT '优秀';ELSEIF chji>=80THEN SELECT '良好';ELSEIF chji>=60THEN SELECT '一般';ELSE SELECT '不及格 阅读全文