title: CREATE PROCEDURE in NetBeans IDE
body: <p>I just wanted to add a simple procedure in Account table in Bank_Admin Schema. </p>
  
  <p>The procedure adds some amount of money to the existing balance an account holder has. I guess, by reading the Sql command, you will figure it out. </p>
  
  <p>But I am getting this error:</p>
  
  <blockquote>
    <p>[Exception, Error code 30,000, SQLState 42X01] Syntax error:
    Encountered "BEGIN" at line 2, column 1.</p>
    
    <p>Line 2, column 1
    Execution finished after 0.036 s, 1 error occurred</p>
  </blockquote>
  
  <p>.Please help me with this code...</p>
  
  <pre><code>CREATE PROCEDURE deposit_in_bank (IN bank_account int, IN deposit_amount int)
  BEGIN 
  UPDATE BANK_ADMIN.ACCOUNT SET balance = balance + deposit_amount WHERE account_no = bank_account
  END
  </code></pre>