title: creating android db table
body: <p>I am new on android. I am trying to create a table in a db using the following code but there is some error</p>
  
  <pre><code>db.beginTransaction();
      try {
  
          db.execSQL("CREATE TABLE IF NOT EXISTS `book` (`id` int(11) NOT NULL AUTO_INCREMENT,`title` varchar(100) NOT NULL,`author_name` varchar(100) NOT NULL,`text_b` text NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;");
          db.setTransactionSuccessful();
      } catch (SQLiteException e) {
          Log.d("Maaz", "Exception 2 : SQL Exception 2 " + e.getMessage());
      } finally {
          db.endTransaction();
      }
  </code></pre>
  
  <p>The above code is giving me the following error</p>
  
  <pre><code>Failure 1 (near "AUTO_INCREMENT": syntax error)
  on 0x23c510 when preparing 'CREATE TABLE IF NOT EXISTS `book` (`id` int(11) NOT NULL AUTO_INCREMENT,`title` varchar(100) NOT NULL,`author_name` varchar(100) NOT NULL,`text_b` text NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;'.
  </code></pre>
  
  <p>Kindly help me. Thanks in advance.</p>