title: What is wrong with this mysql create table query?
body: <p>I have a database in my production server and it works fine... What i did is took a dump of that DB and executed in my local system.. All the other tables are created except one table... So i manually inserted it,</p>
  
  <pre><code>CREATE TABLE `contact` (
    `contactId` int(11) NOT NULL AUTO_INCREMENT,
    `cRefId` int(20) DEFAULT '0',
    `contactFirstName` varchar(100) DEFAULT NULL,
    `contactLastName` varchar(100) DEFAULT NULL,
    `contactPhone` varchar(35) DEFAULT NULL,
    `contactEmail` varchar(150) DEFAULT NULL,
    `organizationid` int(11) NOT NULL,
    `mobileNo` varchar(35) DEFAULT NULL,
    `dor` datetime DEFAULT NULL,
    `doe` datetime DEFAULT NULL,
    `dod` datetime DEFAULT NULL,
    `designation` varchar(50) DEFAULT NULL,
    `income` double DEFAULT NULL,
    `homeloan` tinyint(1) DEFAULT NULL,
    `companyName` varchar(200) DEFAULT NULL,
    `isDeleted` tinyint(1) DEFAULT '0',
    `addressId` int(11) DEFAULT NULL,
    `accgroupid` int(11) DEFAULT NULL,
    `createdBy` int(11) DEFAULT NULL,
    `editedBy` int(11) DEFAULT NULL,
    `deletedBy` int(11) DEFAULT NULL,
    `assignedto` int(11) DEFAULT NULL,
    `industryid` int(11) DEFAULT NULL,
    `note` varchar(150) DEFAULT NULL,
    `twirrerId` varchar(150) DEFAULT NULL,
    `linkedinId` varchar(150) DEFAULT NULL,
    PRIMARY KEY (`contactId`),
    KEY `aa` (`organizationid`),
    KEY `add_id` (`addressId`),
    KEY `idx_contactid` (`contactId`),
    KEY `FK_contact` (`industryid`),
    KEY `fk_contacteditedby_user` (`editedBy`),
    KEY `fk_contactaccount_account` (`accgroupid`,`contactId`),
    KEY `contact_First_Name` (`contactFirstName`) USING BTREE
  ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  </code></pre>
  
  <p>But when i execute this i get the following error,</p>
  
  <pre><code>Error Code : 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
  ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1' at line 35
  </code></pre>