title: Error in syntax while writing a procedure to hash password in Sequel Pro
body: <p>I keep getting a syntax error while trying to create this procedure to hash a password. Not sure why it says there are syntax errors.</p>
  
  <p>The error I keep getting is:</p>
  
  <blockquote>
    <p>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 '@pFirstName varchar(255),
        @pLastName varchar(255),
        @pEmail varchar(255),
        @' at line 2</p>
  </blockquote>
  
  <pre><code>CREATE PROCEDURE `Users`
  @pFirstName varchar(255),
  @pLastName varchar(255),
  @pEmail varchar(255),
  @pPassword NVARCHAR(50),
  @pType int(11),
  @pCreatedAt datetime,
  @pUpdatedAt datetime,
  @pUser_type enum('admin','project-manager','lawyer','anonymous-client','client','external-client','intake-bot'),
  @pUndashPassword NVARCHAR(50),
  @responseMessage NVARCHAR(250) OUTPUT
  
  AS
  BEGIN
  SET NOCOUNT ON
  
  BEGIN TRY
  
      insert into `Users` (`firstName`,`lastName`,`email`, `password`,`type`,`createdAt`,`updatedAt`,`user_type`, `PasswordHash`)
      VALUES(@pFirstName, @pLastName, @pEmail, @pPassword, @pType, @pCreatedAt, @pUpdatedAt, @pUser_type, HASHBYTES('SHA2_512', @pUndashPassword))
  
      SET @responseMessage='Success'
  
  END TRY
  BEGIN CATCH
      SET @responseMessage=ERROR_MESSAGE() 
  END CATCH
  
  END
  </code></pre>