mysql 中exit语句

mysql> SELECT * FROM users;
+----+-------+
| id | name  |
+----+-------+
|  1 | Alice |
|  2 | Bob   |
+----+-------+
2 rows in set (0.00 sec)

mysql> EXIT;
Bye

DELIMITER //

CREATE PROCEDURE GetUsers()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE userId INT;
    DECLARE userName VARCHAR(255);

    -- 假设有一个游标用于遍历用户表
    DECLARE cur CURSOR FOR SELECT id, name FROM users;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO userId, userName;
        IF done THEN
            LEAVE read_loop; -- 当游标遍历完所有记录时退出循环
        END IF;
        SELECT userId, userName;
    END LOOP;

    CLOSE cur;
END //

DELIMITER ;

DELIMITER //

CREATE PROCEDURE GetUsers()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE userId INT;
    DECLARE userName VARCHAR(255);

    DECLARE cur CURSOR FOR SELECT id, name FROM users;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO userId, userName;
        IF done THEN
            LEAVE read_loop; -- 确保标签与 LEAVE 语句匹配
        END IF;
        SELECT userId, userName;
    END LOOP;

    CLOSE cur;
END //

DELIMITER ;