title: MySQL error USING BTREE
body: <p>I have a mysql database I have downloaded from my online server and trying to import on my local mysql but its not working showing this syntax error. I cannot find any errors in this query</p>
  
  <p>This is the error:</p>
  
  <blockquote>
    <p>1064 - 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 'USING BTREE,
      KEY <code>idx_p_id</code> (<code>p_id</code>) USING BTREE,
      KEY ' at line 27 </p>
  </blockquote>
  
  <p>and this is my query:</p>
  
  <pre><code>  PRIMARY KEY (`a_id`),
    UNIQUE KEY `idx_a_id` (`a_id`) USING BTREE,
    KEY `idx_p_id` (`p_id`) USING BTREE,
    KEY `idx_m_id` (`m_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
  </code></pre>