title: MySQL Create Table Error - Table Doesn't Exist
body: <p>I am new to MySQL, and I am having a problem where if I try to create a Table in my newly created Database "recommend", I get the following error:</p>
  
  <blockquote>
    <p>ERROR 1146 (42S02): Table 'recommend.Users' doesn't exist </p>
  </blockquote>
  
  <p>I checked related posts here and on the internet but nothing helped. 
  If I use the MySQL command line I still get the same error.</p>
  
  <pre><code>SELECT DATABASE() FROM DUAL;
  
  +------------+
  
  | DATABASE() |
  
  +------------+
  
  | recommend  |
  
  +------------+
  
  1 row in set (0.00 sec)
  </code></pre>
  
  <p>but then  when i run this command :</p>
  
  <pre><code>mysql&gt; use recommend
  Database changed
  
  mysql&gt; CREATE TABLE Users (UserName VARCHAR(20),password VARCHAR(20),PRIMARY KEY(UserName));
  </code></pre>
  
  <blockquote>
    <p>ERROR 1146 (42S02): Table 'recommend.Users' doesn't exist</p>
  </blockquote>
  
  <p>I also tried using Navicat and still get the same error :( </p>