mysql - 创建程序不起作用，没有给我错误代码

Question

我在让下面的代码工作时遇到了麻烦，当我将其输入mysql时，它没有给我一个特定的错误，它只说没有原因的错误或任何错误号，任何可以帮助我注意到的人我忘记了什么或做错了什么吗？

DELIMITER $$
CREATE PROCEDURE randomMaker(v1 int)
BEGIN
  DROP TABLE IF EXISTS pplGrp
  CREATE TEMPORARY TABLE pplGrp(FirstName_tmp varchar(255), LastName_tmp varchar(255));
  WHILE (v1 > 0) DO
  CALL FirstName_gen();
  CALL LastName_gen();
  INSERT INTO pplGrp (FirstName_tmp, LastName_tmp)values(FirstName_gen(), LastName_gen());
  SET v1 = v1 - 1;
  END WHILE;
  select FirstName_tmp as 'First Name', LastName_tmp as 'Last Name' FROM pplGrp
END;
DELIMITER ;

Answer 1

尝试:

DELIMITER $$

CREATE PROCEDURE randomMaker(v1 int)
BEGIN
  DROP TABLE IF EXISTS pplGrp;
  CREATE TEMPORARY TABLE pplGrp(FirstName_tmp varchar(255), LastName_tmp varchar(255));
  WHILE (v1 > 0) DO
    CALL FirstName_gen();
    CALL LastName_gen();
    INSERT INTO pplGrp (FirstName_tmp, LastName_tmp)values(FirstName_gen(), LastName_gen());
    SET v1 = v1 - 1;
  END WHILE;
  select FirstName_tmp as 'First Name', LastName_tmp as 'Last Name' FROM pplGrp;
END$$

DELIMITER ;