title: Beginners' guide to stored procedures with MySQL?
body: <p>I've Googled but come up with nothing that I can get my head around.</p>
  
  <p>Are the performance gains from using stored procedures significant?</p>
  
  <p>Would I still want to use prepared statements in conjunction with stored procs or is it generally a one or the other thing?</p>
  
  <p>Can I create stored procs through PHPMyAdmin and manage them from there as well?</p>
  
  <p>What would a stored procedure look like for something simple like this-</p>
  
  <pre><code>SELECT * FROM table a 
  INNER JOIN otherTable b 
  ON a.join_id=b.join_id 
  WHERE someVar = :boundParam
  </code></pre>
  
  <p>and how would the PHP work (PDO) to call it and bind its parameter?</p>