- SELECT USER_ID FROM ua; 会返回USER_ID的列表
2.通过循环来逐条更新符合USER_ID的记录
delimiter $$
DROP PROCEDURE IF EXISTS test_update;
create PROCEDURE test_update ()
begin
DECLARE tempUserId BIGINT(20);
DECLARE done INT DEFAULT 0;
DECLARE cur CURSOR FOR SELECT USER_ID FROM ua;
DECLARE continue handler for not found set done = 1;
OPEN cur;
users_loop: LOOP
FETCH cur INTO tempUserId;
IF done=1 THEN
LEAVE users_loop;
END IF;
update tb_cpl_user_info set CHANNEL ='abc123' WHERE user_id = tempUserId;
END LOOP users_loop;
CLOSE cur;
end$$
delimiter ;
call test_update;