mysql - 存储过程与事务给我错误

Question

有人可以告诉我为什么以下存储过程给我一个错误-

CREATE PROCEDURE test(emailA varchar(50))
BEGIN
DECLARE a  INT;
 DECLARE f_id BIGINT;

DECLARE exit handler for sqlexception sqlwarning 
BEGIN    
  SET a = 1;
END; 

DECLARE EXIT HANDLER FOR 1072
BEGIN       
     CALL log_error(1072,'test');
END;   

SELECT id  INTO f_id FROM user WHERE email = emailA;

END// 

错误

您的SQL语法有误。检查与您的MySQL服务器版本相对应的手册以获取正确的语法，以在'sqlwarning BEGIN SET a = 1附近使用；结束;第6行的DECLARE EXIT HANDLER F'

Answer 1

我认为您需要添加逗号

DECLARE exit HANDLER FOR SQLEXCEPTION, SQLWARNING

DECLARE ... HANDLER Syntax