CREATE PROCEDURE in NetBeans IDE
<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>