title: MySQL said: Documentation #1064 You have an error in your SQL syntax
body: <p>I'm trying to move my eCommerce website I created my self from a WAMPSERVER localhost to my online host.<br>
  In order to move the database(which was working perfectly on my localhos), I export it as an sql file,Then I created a new database in my online server to import the database sql file.<br>
  The problem I get after hit import is this :</p>
  
  <p>ErrorSQL query:</p>
  
  <pre><code>-- --------------------------------------------------------
  --
  -- Table structure for table `users`
  --
  CREATE TABLE  `users` (
  
   `UserID` INT( 11 ) NOT NULL COMMENT  'To Identify User',
   `Username` VARCHAR( 255 ) NOT NULL COMMENT  'Username To Login',
   `Password` VARCHAR( 255 ) NOT NULL COMMENT  'Password To Login',
   `Email` VARCHAR( 255 ) NOT NULL COMMENT  'User Email',
   `FullName` VARCHAR( 255 ) NOT NULL COMMENT  'User Full name',
   `GroupID` INT( 11 ) NOT NULL DEFAULT  '0' COMMENT
  );
  </code></pre>
  
  <p>MySQL said: Documentation</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 ')' at line 14 </p>
  </blockquote>
  
  <h2>What is the problem ?</h2>
  
  <p>UPDATE : 
  The problem solved after adding the comment, but I'm getting another error messages like this : </p>
  
  <pre><code>    Error
  SQL query:
  
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE  `users` MODIFY  `UserID` INT( 11 ) NOT NULL AUTO_INCREMENT ,
  AUTO_INCREMENT =9 COMMENT  'To Identify User';
  
  
  MySQL said: Documentation
  
  #1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key 
  </code></pre>