title: Is MySQL Temporary table a shared resource?
body: <p>I have a MySQL stored procedure that uses a temporary table. Assume that my table name is 'temp' and I use it to store some middle data. It will create at the beginning of procedure, and will drop at the end.</p>
  
  <pre><code>CREATE PROCEDURE p()
  BEGIN
  
  CREATE TEMPORARY TABLE \`temp\`(...);
  
  INSERT INTO \`temp\` VALUES(...);
  
  DROP TEMPORARY TABLE \`temp\`;
  
  END;
  </code></pre>
  
  <p>The problem is that this stored procedure may be used by different users concurrently, so I want to know if this can cause any problems (i.e. any conflict in inserted data in temp table). In other word is temp table a shared resource within different calls to the same SP?</p>