title: Attempt to create MySQL temporary table results in error "Base table or view not found"?
body: <p>I'm trying to use a temporary table to hold a bunch of parameters for a search query using the following SQL query:</p>
  
  <pre><code>CREATE TEMPORARY TABLE `patternmatch`
  (`pattern` VARCHAR(".strlen($this-&gt;fullQuery)."));
  INSERT INTO `patternmatch` VALUES ".$insertedValues
  </code></pre>
  
  <p>Where <code>$this-&gt;fullQuery</code> is a number, and inserted values is a set of data with the format:</p>
  
  <p><code>('someData', 'some', 'Data')</code></p>
  
  <p>The query itself checks out. Yet, whenever I try and run this query, I get the error:</p>
  
  <p><code>SQLSTATE[42S02]: Base table or view not found: 1146 Table 'photoquilt.patternmatch' doesn't exist</code></p>
  
  <p>Any reason for this? How can I fix this? If it helps I'm running MySQL and PHP on XAMPP. </p>