title: MySql Stored procedure creation Error
body: <p>I am trying to create a stored procedure in my mysql database usin the below code.I am getting an error.Please help me to solve</p>
  
  <p>My MySQl version is 5.0.51b</p>
  
  <pre><code>CREATE PROCEDURE tv_insert_user(IN firstName VARCHAR(25),
  IN lastName VARCHAR(25), IN emailId VARCHAR(22),IN countryId INT,IN stateId INT)
    BEGIN
       INSERT INTO tv_user_master(FIRST_NAME,LAST_NAME,EMAIL,COUNTRY_ID,STATE_ID) VALUES(firstName,lastName,lname,emailId,countryId,stateId)
    END
  </code></pre>
  
  <p>ERROR:</p>
  
  <hr>
  
  <p>Error Code : 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 'END' at line 5
  (0 ms taken)</p>