title: How to fix syntax error when escaping table name?
body: <pre><code>CREATE TABLE 'test'.'sensor' (
  
  'id' INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  'time' TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  'value' VARCHAR( 10 ) NOT NULL
   );
  </code></pre>
  
  <p>This is my code which I entered in phpMyAdmin. And when I pressed go I got the following error:</p>
  
  <blockquote>
    <p>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''test'.'sensor' (
    'id' INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    'time' TIMES' at line 1</p>
  </blockquote>
  
  <p>I have tried changing some statements but couldn't get the error.</p>