title: List temporary table columns in mysql
body: <p>I have created one temporary table named "table1". I am trying to list the columns of my temp table. I am not getting any values. Here is my mysql query.</p>
  
  <pre><code>SELECT column_name
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE table_name = 'table2';
  </code></pre>
  
  <p>Any body help me please?
  Thanks</p>