MySQL存储过程出现事务语法错误

Question

实际上，我已经从SQL Server移至MySQL，看来SQL语法完全不同，我很难完成创建以下存储过程的时间，因为我会遇到不同的错误。这是我第一次在Stackoverflow上发布，如果格式不友好，则表示歉意。提前致谢。

1-声明在此职位上无效，除了EOF，';'

2-设置在此位置无效，除了eof';'

3-提交在此职位上无效，除了eof';';'

    DELIMITER //
   
    CREATE PROCEDURE CreateCustomer(IN email VARCHAR(100),IN pass VARCHAR(128),IN phoneNumber VARCHAR(12),IN gender INT,IN birthday DATE)
    BEGIN

    DECLARE last_user_inserted INT DEFAULT 0;

    DECLARE EXIT HANDLER FOR SQLEXCEPTION 
    BEGIN
    ROLLBACK; 
     RESIGNAL;
    END;
  
    START TRANSACTION;
    INSERT INTO users (emailAddress,passwordHash,phoneNumber) VALUES(email,pass,phoneNumber)

     SET last_user_inserted = LAST_INSERT_ID();
    INSERT INTO customers (user_id,gender,birthday) VALUES (last_user_id,gender, birthday)
  
      COMMIT;

     END;

    DELIMITER ; 

Answer 1

谢谢@P.Salmon，工作得很好。

DELIMITER //
CREATE PROCEDURE CreateCustomer(IN email VARCHAR(100),IN passVARCHAR(128),IN phoneNumber VARCHAR(12),IN gender INT,IN birthday DATE)
BEGIN

DECLARE last_user_inserted INT DEFAULT 0;

DECLARE EXIT HANDLER FOR SQLEXCEPTION 
BEGIN
ROLLBACK; 
 RESIGNAL;
 END;

  START TRANSACTION;
  INSERT INTO users (emailAddress,passwordHash,phoneNumber) VALUES(email,pass,phoneNumber);

 SET last_user_inserted = LAST_INSERT_ID();
 INSERT INTO customer (user_id,gender,birthday) VALUES (last_user_id,gender, birthday);

  COMMIT;

END//

DELIMITER ;