title: Qt/MySQLITE errors on simple query which MySQL accepts
body: <p>I have a QSqlDatabase of QSQLITE type which give me this error</p>
  
  <pre><code>near "AUTO_INCREMENT": syntax error Unable to execute statement
  </code></pre>
  
  <p>on this statement (which MySQL executes correctly)</p>
  
  <pre><code>CREATE TABLE `Student` (
  `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  `fullname` TEXT NOT NULL ,
  `date_of_birth` TIMESTAMP NOT NULL ,
  `date_enrolled` TIMESTAMP NOT NULL ,
  `current_academic_year` INT NOT NULL
  )
  </code></pre>
  
  <p>I tried <a href="http://sqlite.org/autoinc.html" rel="nofollow">changing <code>AUTO_INCREMENT</code> to <code>AUTOINCREMENT</code></a> and then to <a href="https://sqlite.org/faq.html#q1" rel="nofollow"><code>id NOT NULL INTEGER PRIMARY KEY</code></a>but neither made any difference.</p>
  
  <p>What's wrong with it?</p>