|
CREATE PROCEDURE Upmember()
BEGIN
#定义 变量
DECLARE a int;
#这个用于处理游标到达最后一行的情况
DECLARE s int default 0;
#声明游标cursor_name(cursor_name是个多行结果集)
DECLARE cursor_name CURSOR FOR select uid from member where scode<>'' and unix_timestamp(now())> end_time;
#设置一个终止标记
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET s=1;
#打开游标
OPEN cursor_name; |
|