Syntax error with SQLite query in Android

Question

I am trying to create a new SQLite database in Android. Here is my onCreate method:

public static final String DATABASE_NAME = "eventList.db";
public static final String TABLE_NAME = "event_table";
public static final String COL1 = "ID";
public static final String COL2 = "EVENTNAME";
public static final String COL3 = "UNIXTIMESTAMP";
public static final String COL4 = "PARTICIPANTS";
public static final String COL5 = "LOCATION";
public static final String COL6 = "LOCATIONNAME";
@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
    String createTable = "CREATE TABLE " + TABLE_NAME + "(ID INTEGER PRIMARY KEY AUTOINCRIMENT, "
            + " EVENTNAME TEXT, UNIXTIMESTAMP INTEGER, PARTICIPANTS TEXT, LOCATION TEXT, LOCATIONNAME TEXT)";
    sqLiteDatabase.execSQL(createTable);
}

This is throwing a syntax error:

android.database.sqlite.SQLiteException: near "AUTOINCRIMENT": syntax error (code 1): , while compiling: CREATE TABLE event_table(ID INTEGER PRIMARY KEY AUTOINCRIMENT, EVENTNAME TEXT, UNIXTIMESTAMP INTEGER, PARTICIPANTS TEXT, LOCATION TEXT, LOCATIONNAME TEXT)

Please do note that PARTICIPANTS is going to be a custom object, and LOCATION is going to be a LatLng object.

How can I solve the error?

MikeT · Accepted Answer · 2017-08-21 02:13:12Z

2

ID INTEGER PRIMARY KEY AUTOINCRIMENT is incorrect it should be ID INTEGER PRIMARY KEY AUTOINCREMENT

However, coding AUTOINCREMENT, is probably best not coded at all, as per SQLite Autoincrement . ID will still be a unique identifier.

You may also find it advantageous to use _id instead of ID as the column name. Sometimes _id is required e.g. as for CursorAdapters.

So I'd suggest using _id INTEGER PRIMARY KEY

answered Aug 21, 2017 at 2:13

MikeT

57.9k16 gold badges61 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jamesc · Accepted Answer · 2017-08-21 23:29:34Z

0

You have a typo in

 String createTable = "CREATE TABLE " + TABLE_NAME + "(ID INTEGER PRIMARY KEY AUTOINCRIMENT, "

Note that AUTOINCRIMENT should be spelt AUTOINCREMENT

plus ID should be _id Also, as you have gone to the trouble of setting up constants why not use them to save on further potential typos? e.g. Instead of

+ " EVENTNAME TEXT

Why not use

+ COL2 + " TEXT

etc...

Could I suggest you read up on how to create databases here It is a superb tutorial and shows best practices

edited Aug 21, 2017 at 23:29

answered Aug 21, 2017 at 2:11

jamesc

12.9k15 gold badges80 silver badges119 bronze badges

Comments

Sagar Patel · Accepted Answer · 2017-08-21 04:48:11Z

try this

public static final String DATABASE_NAME = "eventList.db";
public static final String TABLE_NAME = "event_table";
public static final String COL1 = "ID";
public static final String COL2 = "EVENTNAME";
public static final String COL3 = "UNIXTIMESTAMP";
public static final String COL4 = "PARTICIPANTS";
public static final String COL5 = "LOCATION";
public static final String COL6 = "LOCATIONNAME";
@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
    String createTable = "CREATE TABLE " + TABLE_NAME + "(ID INTEGER PRIMARY KEY AUTOINCREMENT, "
            + " EVENTNAME TEXT, UNIXTIMESTAMP INTEGER, PARTICIPANTS TEXT, LOCATION TEXT, LOCATIONNAME TEXT)";
    sqLiteDatabase.execSQL(createTable);
}

I Think Your error in spelling mistake Replace AUTOINCRIMENT to AUTOINCREMENT.

Collectives™ on Stack Overflow

Syntax error with SQLite query in Android

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related