Asignar valor a variable dentro de if

[jnavarrete2311]

Acabo de tratar de crear el SP con el codigo que me pasaste pero sigo teniendo los mismos problemas error con la declaracion de variables:

Error
consulta SQL:

CREATE PROCEDURE sp_InsertCustomer( IN Firstname VARCHAR( 100 ) , IN Lastname VARCHAR( 100 ) , IN Email VARCHAR( 100 ) , IN Birthday DATETIME, IN Company VARCHAR( 100 ) , IN Address1 VARCHAR( 100 ) , IN Postcode INT, IN City VARCHAR( 100 ) , IN Phone INT ) BEGIN DECLARE regs INT;


MySQL ha dicho:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 14