Android table creation Failure (near “autoincrement”: syntax error)?

by

In short: In SQLite a column declared INTEGER PRIMARY KEY will autoincrement. There is no autoincrement keyword in SQLite, that is why you are getting an error.

You can find out more on SQLite FAQ.

EDIT: just writing integer primary key it is enough. SQLite will automatically increment your ids.

EDIT2: Your onUpgrade() method should look like this :

  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        if (newVersion > oldVersion) {
            Log.w("MyAppTag","Updating database from version " + oldVersion + " to "
                    + newVersion + " .Existing data will be lost.");
            db.execSQL("DROP TABLE IF EXISTS " + MY_TABLE);
            db.execSQL("DROP TABLE IF EXISTS " + MY_TABLE2);
            onCreate(db);
        }

More Related Contents:

  1. Android :: SQLIte Db don't insert the datas
  2. How to retrieve and display data from a database to TextView
  3. Sqlite for Android
  4. Best way to work with dates in Android SQLite [closed]
  5. How can I create a user-defined function in SQLite?
  6. SQLiteDatabase.query method
  7. About “_id” field in Android SQLite
  8. Import .csv file to Sqlite in Android
  9. Debugging sqlite database on the device
  10. How to insert a SQLite record with a datetime set to ‘now’ in Android application?
  11. Android SQLite: Update Statement
  12. How to delete SQLite database from Android programmatically
  13. Bulk Insertion on Android device
  14. Android Sqlite selection args[] with int values
  15. SQLite simultaneous reading and writing
  16. update sql database with ContentValues and the update-method
  17. SQLiteDatabase close() function causing NullPointerException when multiple threads
  18. sqlite encryption for android
  19. Android quotes within an sql query string
  20. Android SQLite rawquery parameters
  21. Saving ArrayLists in SQLite databases
  22. How to access an existing sqlite database in Android?
  23. How to convert milliseconds to date in SQLite
  24. DB File in Assets Folder. Will it be Updated?
  25. Backup/restore sqlite db in android [duplicate]
  26. SQLite android column not found
  27. SQlite – Android – Foreign key syntax
  28. Inserting values to SQLite table in Android
  29. Using COLLATE in Android SQLite – Locales is ignored in LIKE statement
  30. SQLite Foreign Key

Leave a Comment