title: ERROR 1064 (42000): mysql 5.0.77 server : tablespace creation error
body: <p>Server version: 5.0.77 Source distribution</p>
  <p>I am getting error while creation of tablespaces</p>
  <pre><code>CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' ENGINE=INNODB;
  </code></pre>
  <p>Error is</p>
  <pre><code>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 'TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' ENGINE=INNODB' at line 1'
  </code></pre>
  <p>I understand, There are two different types of quotation marks in MySQL (` for column names and ' for strings). Why i am getting above error?</p>