mysql建立存储过程报错_MySQL 创建存储过程报错

mysql> delimiter $$

mysql> CREATE FUNCTION check_rollbackPatch(THE_REFERNCE_LABEL VARCHAR(75), THE_COLUMN_NAME VARCHAR(75), THE_INSTALL_VERSION VARCHAR(75), THE_VERSION_LEVEL_TABLE_NAME VARCHAR(75))

->     RETURNS INTEGER DETERMINISTIC

->     BEGIN

->         DECLARE INSTALL_VERSION VARCHAR(80) DEFAULT NULL;

->         DECLARE REFERENCE_LABEL VARCHAR(80) DEFAULT NULL;

->         DECLARE THE_QUERY VARCHAR(500) DEFAULT NULL;

->         DECLARE too_many_rows CONDITION FOR 1172;

->         DECLARE CONTINUE HANDLER FOR too_many_rows

->         BEGIN

->         SELECT concat('[INFO]    Several ', THE_REFERNCE_LABEL, ' references found.');

->         RETURN 0;

->         END;

->         DECLARE CONTINUE HANDLER FOR NOT FOUND

->         BEGIN

->         /*SELECT c