title: mysql trouble with information_schema.tables
body: <p>-edit2- 3hrs later and still have the same problem. I am using the noinstall archive package.
  -edit- maybe someone can tell me a better way to check if a table exist?</p>
  
  <p>I have a function in my lib to check if a table exist which i asked how to do in the past.</p>
  
  <p>I deleted my database and created it again. My code didnt create the tables properly. After debugging i decided to write the below.</p>
  
  <pre><code>mysql&gt; SELECT table_schema, table_name FROM information_schema.tables WHERE tabl
  e_schema = 'mydb' AND table_name='ApprovePost';
  +--------------+-------------+
  | table_schema | table_name  |
  +--------------+-------------+
  | mydb         | ApprovePost |
  +--------------+-------------+
  1 row in set (0.00 sec)
  </code></pre>
  
  <p>Weird... mydb was dropped and created again (i wrote <code>drop database mydb;</code> and <code>create database mydb;</code>. It should be gone?). Lets find out what exists</p>
  
  <pre><code>mysql&gt; SELECT table_schema, table_name FROM information_schema.tables WHERE tabl
  e_schema = 'mydb';
  Empty set (0.00 sec)
  </code></pre>
  
  <p>Not only do i not know why the first statement shows tables which is wrecking my code, i dont know why this is not showing any tables (in that database).</p>
  
  <p>note: The databases should all be innodb. Also this is a fresh windows install and i may have configured something wrong.</p>
  
  <hr>
  
  <p>Bonus weirdness.</p>
  
  <pre><code>mysql&gt; drop database mydb;
  ERROR 1008 (HY000): Can't drop database 'mydb'; database doesn't exist
  mysql&gt; SELECT table_schema, table_name FROM information_schema.tables WHERE tabl
  e_schema = 'mydb';
  Empty set (0.00 sec)
  
  mysql&gt; SELECT table_schema, table_name FROM information_schema.tables WHERE tabl
  e_schema = 'mydb' AND table_name='ApprovePost';
  +--------------+-------------+
  | table_schema | table_name  |
  +--------------+-------------+
  | mydb         | ApprovePost |
  +--------------+-------------+
  1 row in set (0.00 sec)
  </code></pre>