title: Trying to create a transaction in phpmyadmin
body: <p>Trying to create a transaction in phpmyadmin using the routine panel. I want to do an insert and an update:</p>
  
  <pre><code>START TRANSACTION;
  
  INSERT INTO inventoryitems (item, quantity, userid)
  VALUES(item, quantity, userid);
  
  UPDATE users
  SET cash = cash - (quantity * unitbuyprice);
  
  COMMIT;
  </code></pre>
  
  <p>You can see the create/edit routine panel in the screen shot below:</p>
  
  <p><a href="https://i.stack.imgur.com/1XCq4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1XCq4.png" alt="Create Routine"></a></p>
  
  <p>Below is the error I get:</p>
  
  <p>The following query has failed: "CREATE DEFINER=<code>root</code>@<code>localhost</code> PROCEDURE <code>InsertInventoryItem</code>(IN <code>item</code> VARCHAR(255), IN <code>quantity</code> INT, IN <code>userid</code> INT, IN <code>unitbuyprice</code> INT) NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER START TRANSACTION; INSERT INTO inventoryitems (item, quantity, userid) VALUES(item, quantity, userid); UPDATE users SET cash = cash - (quantity * unitbuyprice); COMMIT;"
  MySQL said: #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 'INSERT INTO inventoryitems (item, quantity, userid) VALUES(item, quantity, user' at line 3</p>
  
  <p>If I remove the Start Transaction, Commit and either the insert or update then the procedure is fine. IE just a single statement works fine but multiple statements always gives an error.</p>
  
  <p>What am I missing when I want to include multiple statements in a procedure.
  I have tried with and without the semi colon delimiter.</p>
  
  <p>This stuff just works with MS SQL. I have created Procedures with hundreds of statements inside before.</p>
  
  <p>Cheers for the Help in advance.</p>