title: MySQL Type=MyISAM Error
body: <p>I am working on my forums website earlier this month and came across a little problem. Unfortunately, everything has gone smoothly except for my database. I was making a table in it called <code>users</code> with this script...</p>
  
  <pre><code>CREATE TABLE `users` (
  `id` int(4) NOT NULL auto_increment,
  `username` varchar(65) NOT NULL default '',
  `password` varchar(65) NOT NULL default '',
  PRIMARY KEY (`id`)
  ) TYPE=MyISAM AUTO_INCREMENT=2 ;
  </code></pre>
  
  <p>When I tried to run the code however, I get this error...</p>
  
  <blockquote>
    <p><strong>#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 'TYPE=MyISAM AUTO_INCREMENT=2' at line 6</strong></p>
  </blockquote>
  
  <p>I have dealt with this once before by running it with <code>Engine</code>, but I got two different errors when I did that this time.</p>
  
  <p>I did some research on it and thought my MySQL code may be outdated, but when I ran the code on the same version of MySQL from my one of my employees computers, it worked fine. After that, I tried running it on an older version of MySQL from my computer again, but still got an error. </p>
  
  <p>My assumption is it may be a simple mistake, or a computer/server error. I would try to just do my website on a different computer, speaking that I own a computer shop, but I don't want to have to start all over since it is localhost. Also, I am at a loss for flash drives and with the weather we have been getting out here in north Scandinavia, there is no way I will be able to get it shipped any time soon.</p>
  
  <p>So, as a last resort I decided to ask you guys. Help is appreciated.</p>