首页 > 数据库技术 > 详细

MYSQL存储过程学习

时间:2015-04-17 00:57:37      阅读:269      评论:0      收藏:0      [点我收藏+]

1、游标的使用

BEGIN
    DECLARE done INT DEFAULT 0;
    DECLARE userid INT;
    DECLARE rs CURSOR FOR SELECT `uid` FROM sinbegin_user WHERE service = 0;/*定义游标*/
    DECLARE CONTINUE HANDLER FOR SQLSTATE 02000 SET done = 1;/*异常处理*/
    OPEN rs;/*打开游标*/
        FETCH NEXT FROM rs INTO userid;
        REPEAT/*遍历数据表*/
            IF NOT done THEN
                UPDATE sinbegin_user SET service = 1 WHERE uid = userid;
            END IF;
        FETCH NEXT FROM rs INTO userid;
        UNTIL done END REPEAT;
    CLOSE rs;/*关闭游标*/
END

 2、IF条件判断的使用

语法

IF expression THEN commands
   [ELSEIF expression THEN commands]
   [ELSE commands]
   END IF;

示例代码

IF CurrentLingQi >= 1800 THEN
    UPDATE socialrelation SET LingQi = 1800 WHERE NodeName = ShizuName;
ELSE
     UPDATE socialrelation SET LingQi = LingQi + 60 WHERE NodeName = ShizuName;
END IF;

 

MYSQL存储过程学习

原文:http://www.cnblogs.com/mssql8/p/4433754.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!