title: Special Characters in MySQL Table Name
body: <p>I created a table as follows:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS 'e!' (
  `aa` int(11) unsigned NOT NULL auto_increment,
  `showName` TEXT NOT NULL default '',
  `startDateTime` DATETIME NOT NULL default '',
  `endDateTime` DATETIME NOT NULL default '',
  PRIMARY KEY  (`aa`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8
  </code></pre>
  
  <p>Then tried to insert with the query:</p>
  
  <pre><code>INSERT INTO e! (showname, startDateTime, endDateTime) VALUES('E! News ', '2012-05-03 19:00:00', '2012-05-03 20:00:00')
  </code></pre>
  
  <p>And it errors due to the <code>!</code> in the table name, I'm assuming <code>!</code> is a special character in mysql.  I tried to escape it but the query still failed.</p>
  
  <p>So, can I have special characters like <code>!</code> or <code>&amp;</code> in the table name? If yes, then I probably have to encode them somehow?</p>
  
  <p>Thanks.</p>