带IN的存储过程

Question

希望大家都做得好！

需要存储过程方面的帮助。创建过程时出现以下错误。非常感谢您的帮助。

错误：#1064-您的SQL语法有错误；查看与您的MySQL服务器版本对应的手册，了解使用near'CREATE PROCEDURE regi_email（在电子邮件VARCHAR（255）中，counti OUT INT）的正确语法

开始

“在3号线

我的程序如下：

DELIMITER $$

USE hsiedwzw_booking

CREATE PROCEDURE regi_email (IN email VARCHAR(255), counti OUT INT)

BEGIN

DECLARE bContinue INTEGER;

SELECT COUNT(*) INTO bContinue FROM parent_reg_email WHERE reg_email =email;

    IF bContinue=0;

THEN SET @counti=1;

    ELSE SELECT COUNT(*) INTO bContinue FROM ets_bookings WHERE c_email =email;

         IF bContinue=0;

         SET @counti=2;


         ELSE SET @counti=3;

END IF;

END
$$
DELIMITER;

Answer 1

您在这一行有错误，需要更改如下：

CREATE PROCEDURE regi_email (IN email VARCHAR(255),OUT counti  INT)

编辑：

#DEFINER=`root`@`localhost`  is for your server ;;

USE hsiedwzw_booking;

DELIMITER $$

CREATE DEFINER=`root`@`localhost` PROCEDURE `activeFor_accounthead`(IN email VARCHAR(255),OUT  counti INT)

BEGIN

DECLARE bContinue INTEGER;

SELECT COUNT(*) INTO bContinue FROM parent_reg_email WHERE reg_email =email;

    IF bContinue=0;

THEN SET @counti=1;

    ELSE SELECT COUNT(*) INTO bContinue FROM ets_bookings WHERE c_email =email;

         IF bContinue=0;

         SET @counti=2;


         ELSE SET @counti=3;

END IF;
END$$
DELIMITER ;