Android SQLite - Primary Key - Inserting into table

Question

Im in my final stages of creating a database for my android app, however, I cannot seem to get my primary key to increment. Here is my code where I set it up, ``` public class DatabaseHandler extends SQLiteOpenHelper { // All Static variables // Database Version private static final int DATABASE_VERSION = 17; // Database Name private static final String DATABASE_NAME = "journeyManager"; // Contacts table name public static final String TABLE_JOURNEY = "journey"; // Contacts Table Columns names private static final String KEY_P = "key"; private static final String KEY_ID = "id"; private static final String KEY_DIST = "distance"; private static final String KEY_MPG = "mpg"; private static final String KEY_COST = "cost"; public DatabaseHandler(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION); } // Creating Tables @Override public void onCreate(SQLiteDatabase db) { String CREATE_JOURNEY_TABLE = "CREATE TABLE " + TABLE_JOURNEY + "(" + KEY_P + " INTEGER PRIMARY KEY,"…

Accepted Answer

To make the database auto-generate the primary key for you, just don't specify it yourself. Remove this line from the insert code:

```
values.put(KEY_P, journey.getpKey());
```

You can capture the generated id from the return value of `insert()`.

Also, I want the data to be in descending order, to do this, I use DESC, but where shall I place this?

Assuming this applies to `getAllJourneys()` where you do a `rawQuery()`, just add the `ORDER BY` directly in the SQL:

```
String selectQuery = "SELECT  * FROM " + TABLE_JOURNEY + " ORDER BY " + KEY_P + " DESC";
```

Android SQLite - Primary Key - Inserting into table

Solution

Problem