title: Can't figure out stored procedure, error at END
body: <p>I was hoping you could help me out...</p>
  
  <p>I do know some SQL, but I'm new to mySQL... and there's this simple query that I just can't figure out what's wrong with it:</p>
  
  <pre><code>CREATE PROCEDURE inserttoscrapbookSD
  (owner1 VARCHAR(50),
  poster1 VARCHAR(50),
  Scrap1 VARCHAR(50),
  
  )
  BEGIN
  
  INSERT INTO scrapbook (Owner)
  
  VALUES(owner1)
  
  END
  </code></pre>
  
  <p>I know there are a lot of variables being passed, but just using one variable at the moment because if it works for one, it'll work for all. I tried with and without a semicolon ( ; ) at the end of <code>END</code> and <code>VALUES(owner1)</code> but no luck. It says:</p>
  
  <blockquote>
    <p>#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 ') BEGIN INSERT INTO scrapbook (Owner) VALUES(owner1) END' at
    line 6</p>
  </blockquote>