title: Store the result of `show create procedure procedure_name` into a variable in MySql
body: <p>I want to get the code used to create an existing procedure by using the command
  <code>show create procedure</code>  and then store it in a variable. All this inside a procedure.</p>
  
  <h3>Problem</h3>
  
  <ul>
  <li><code>Set @var</code> for creating user defined variables only works when the result contains one row and one column.</li>
  <li><code>show create procedure proc_name</code> returns multiple columns and I cant select the specific one which is <code>Create Function</code></li>
  </ul>
  
  <h3>Question</h3>
  
  <p>How can I save the code for creating a procedure into a variable for later use.</p>