根据变量更新数据-存储过程

DELIMITER $$

CREATE
    /*[DEFINER = { user | CURRENT_USER }]*/
    PROCEDURE `yoyo`.`bb`(IN circleId VARCHAR(36),IN newhostId VARCHAR(36))
    /*LANGUAGE SQL
    | [NOT] DETERMINISTIC
    | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
    | SQL SECURITY { DEFINER | INVOKER }
    | COMMENT 'string'*/
    BEGIN

    DECLARE cmid VARCHAR(36);
    SELECT cm.id INTO cmid  FROM tf_circle_member cm WHERE cm.circleId=circleId AND cm.memberType = 4;
    UPDATE tf_circle_member SET memberType = 1,fansNo = 2 WHERE id =cmid;
    UPDATE tf_circle_member SET memberType = 4,fansNo = 1 WHERE circleId=circleId AND userId=newhostId;
    UPDATE tf_circle SET hostId=newhostId  WHERE Id=circleId;
    END$$

DELIMITER ;