title: (1) near "AUTO_INCREMENT": syntax error when altering table
body: <p>I'm trying to alter an SQLite table defined as follows:</p>
  
  <pre><code>    String CREATE_TABLE="CREATE TABLE IF NOT EXISTS " + tab_NAME + " ("
                              + row_ID + " INTEGER PRIMARY KEY , "
                              + row_NAME + " TEXT, "
                              + row_EMAIL + " TEXT, "
                              + row_WEBSITE + " TEXT, "
                              + row_TELEPHONE1 + " TEXT, "
                              + row_TELEPHONE2 + " TEXT, "
                              + row_TELEPHONE3 + " TEXT, "
                              + row_TELEPHONE4 + " TEXT, "
                              + row_TELEPHONE5 + " TEXT);";
          db_name.execSQL(CREATE_TABLE);
  
          String newTab="CREATE TABLE IF NOT EXISTS temp ("
                  + row_ID + " INTEGER PRIMARY KEY AUTOINCREMENT , "
                  + row_NAME + " TEXT, "
                  + row_EMAIL + " TEXT, "
                  + row_WEBSITE + " TEXT, "
                  + row_TELEPHONE1 + " TEXT, "
                  + row_TELEPHONE2 + " TEXT, "
                  + row_TELEPHONE3 + " TEXT, "
                  + row_TELEPHONE4 + " TEXT, "
                  + row_TELEPHONE5 + " TEXT);";
          db_name.execSQL(newTab);
  </code></pre>
  
  <p>And here is the auto_increment alter statement:</p>
  
  <pre><code>    String alter="ALTER TABLE temp AUTO_INCREMENT=1;";
      ourDatabase.execSQL(alter);
  </code></pre>
  
  <p>I got an error saying <code>(1) near AUTO_INCREMENT: syntax error</code></p>
  
  <p>what's wrong?? any help??</p>