title: Stored Procedures Using MySQL Workbench
body: <p>Very new to the environment, I have a question about a line that's added to the end of my code. The guide I'm following is:</p>
  
  <p><a href="http://net.tutsplus.com/tutorials/an-introduction-to-stored-procedures/" rel="noreferrer">http://net.tutsplus.com/tutorials/an-introduction-to-stored-procedures/</a></p>
  
  <p>If anyone has a better one regarding MySQL stored procedures, I'm all ears.</p>
  
  <p><strong>Before I ask, this is the environment I'm using:
  OS: Windows 7 / WAMP (MySQL 5.5.24)  / MySQL Workbench</strong></p>
  
  <p>I'm instructed to define a delimiter; in my case I'm sticking with the default '$$.'</p>
  
  <p>The stored procedure I created is:</p>
  
  <pre><code>DELIMITER $$
  CREATE PROCEDURE test.`p2` ()
  LANGUAGE SQL
  DETERMINISTIC
  COMMENT 'Adds "nson" to first and last names in the record.'
  BEGIN
  SELECT 'Hello World';
  END $$
  </code></pre>
  
  <p>When I apply this stored procedure and I get the review screen, I see a new line of code added;</p>
  
  <p>At the bottom:</p>
  
  <pre><code>DELIMITER ;
  </code></pre>
  
  <p>This lats line; is it added because the DELIMITER statement announces a block within which the defined delimiters ($$) can be used and thus closes the block in the end?</p>