title: syntax error : 1064 , when creating a stored procedure
body: <pre><code>CREATE table parent_user
   ( userid int  auto_increment PRIMARY KEY,
   Username varchar(100) NOT NULL,
      Password varchar(200) NOT NULL,
      Email varchar(200) NOT NULL
  
   );
  </code></pre>
  
  <p>EDIT : OK so I made some changes:</p>
  
  <pre><code>CREATE PROCEDURE `parent_reg` (
  pUserName varchar(100)
  pPassword varchar(200)
  pEmail varchar(200)
  )
  as
  Begin
  Declare Count int
  Declare ReturnCode int
  
  Select Count = Count(Username)
  from parent_user where Username = @Username
  If Count &gt; 0
  Begin
        Set ReturnCode = -1
      End
      Else
      Begin 
        Set ReturnCode = 1
        insert into parent_user values
        (pUserName, pPassword, pEmail)
      End
      Select pReturnCode as ReturnValue 
      End
  </code></pre>
  
  <p>But I still got the same error-
  Error 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 'pPassword varchar(200) pEmail varchar(200) ) ....'</p>
  
  <p>The syntax error is at 'pPassword varchar(200)'</p>