摘要: DROP PROCEDURE PROC_Z4;CREATE PROCEDURE proc_z4()BEGIN DECLARE card CHAR(20); DECLARE count INT; SELECT count(*) INTO count FROM Z4; ... 阅读全文
posted @ 2016-01-08 17:22 wujf 阅读(170) 评论(0) 推荐(0) 编辑
摘要: 存储过程代码如下:CREATE PROCEDURE proc_sum2(IN n INT,OUT sum INT,OUT j INT)BEGIN DECLARE i INT; SET i=1; SET sum=0; SET j=111; WHILE i<=n d... 阅读全文
posted @ 2016-01-08 15:34 wujf 阅读(3235) 评论(0) 推荐(0) 编辑