怎么在MySQL中创建嵌套存储过程

CREATE PROCEDURE my_procedure() 
BEGIN 
   -- SQL 代码
END;

CREATE PROCEDURE my_nested_procedure() 
BEGIN 
   CALL my_procedure(); 
END;

CALL my_nested_procedure();

CREATE PROCEDURE my_nested_procedure_2() 
BEGIN 
   CALL my_procedure(); 
   CALL my_nested_procedure(); 
END;

-- 创建一个存储过程，用于添加用户
CREATE PROCEDURE add_user(IN user_name VARCHAR(255), IN user_age INT, OUT result VARCHAR(255))
BEGIN
   INSERT INTO users(name, age) VALUES(user_name, user_age);
   SET result = '添加成功';
END;

-- 创建一个嵌套存储过程，用于根据给定用户的年龄添加用户
CREATE PROCEDURE add_users_by_age(IN user_age INT)
BEGIN
  DECLARE current_user VARCHAR(255);
  DECLARE current_age INT;
  DECLARE user_cursor CURSOR FOR SELECT name, age FROM users WHERE age = user_age;
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET @done = TRUE;
  OPEN user_cursor;
  SET @done = FALSE;
  LOOP_RECORDS: LOOP
    FETCH user_cursor INTO current_user, current_age;
    IF @done THEN
      LEAVE LOOP_RECORDS;
    END IF;
    -- 调用之前创建的添加用户的存储过程
    CALL add_user(current_user, current_age, @result);
  END LOOP LOOP_RECORDS;
  CLOSE user_cursor;
END;

-- 调用嵌套存储过程
CALL add_users_by_age(30);