title: mySQL Uppercase Table Name
body: <p>I have a database with tables already in the database. There is a table called Character that I am trying to access to add an additional column. However any command that I use with the table Character gives me the following error:</p>
  
  <pre><code>    mysql&gt; SHOW FIELDS FROM Character;
  ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Character' at line 1
  </code></pre>
  
  <p>I've tried the following commands:</p>
  
  <pre><code>mysql&gt; SHOW FIELDS FROM "Character";
  mysql&gt; SHOW FIELDS FROM 'Character';
  mysql&gt; SHOW FIELDS FROM Character;
  </code></pre>
  
  <p>All three give me the same error. I have already selected the appropriate database that contains the Character table using the command "USE dbname;"</p>