title: Key commands for creating temporary tables
body: <p>I am creating temporary tables in stored procedures. Wanted to know what commands to include in procedure to avoid conflicts?</p>
  
  <p>i usually use below syntax</p>
  
  <pre><code> CREATE TEMPORARY TABLE IF NOT EXISTS temp_shipmentcount
  </code></pre>
  
  <p>and use </p>
  
  <p>drop command at end. </p>
  
  <p>should i add drop command at beginning of procedure also?</p>