delimiter //
drop PROCEDURE IF EXISTS curdeom;
create PROCEDURE curdeom()
BEGIN
DECLARE i INT DEFAULT 0;
DECLARE done INT DEFAULT 0;
DECLARE weibonum,userid INT;
DECLARE cur1 CURSOR FOR SELECT count(*),user_id FROM eminfondb.em_weibo3 GROUP BY user_id; #定义光标
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
OPEN cur1; #打开光标
loop_curl:LOOP
SET i = i + 1;
FETCH cur1 INTO weibonum,userid; #遍历光标
replace INTO user_count(user_id,num,msg_num) SELECT user_id,weibonum,msg_num FROM user_count where user_id = userid;
IF (done = 1) THEN
LEAVE loop_curl;
END IF;
END LOOP loop_curl;
SELECT i;
CLOSE cur1; #关闭光标
END
//
drop PROCEDURE IF EXISTS curdeom;
create PROCEDURE curdeom()
BEGIN
DECLARE i INT DEFAULT 0;
DECLARE done INT DEFAULT 0;
DECLARE weibonum,userid INT;
DECLARE cur1 CURSOR FOR SELECT count(*),user_id FROM eminfondb.em_weibo3 GROUP BY user_id; #定义光标
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
OPEN cur1; #打开光标
loop_curl:LOOP
SET i = i + 1;
FETCH cur1 INTO weibonum,userid; #遍历光标
replace INTO user_count(user_id,num,msg_num) SELECT user_id,weibonum,msg_num FROM user_count where user_id = userid;
IF (done = 1) THEN
LEAVE loop_curl;
END IF;
END LOOP loop_curl;
SELECT i;
CLOSE cur1; #关闭光标
END
//