.SQLiteException: near ",": syntax error (code 1): , while compiling:

Question

What am I missing? Something with a "," but I seem to be looking in the wrong place. This is my code:

private static final String DATABASE_CREATE =
        "CREATE TABLE if not exists " + SQLITE_TABLE + " (" +
                KEY_ROWID + " integer PRIMARY KEY autoincrement," +
                KEY_CURSUS + "," +
                KEY_ONDERDEEL + "," +
                KEY_GAME + "," +
                KEY_TIJD + "," +
                KEY_WEB + "," +
                KEY_CHECK + "," +
                " UNIQUE (" + KEY_ROWID +"));";

And this is the error I get:

 Caused by: android.database.sqlite.SQLiteException: near ",": syntax error (code 1): , while compiling: CREATE TABLE if not exists Games_getset (_id integer PRIMARY KEY autoincrement,cursus,onderdeel,game,tijd,web,check, UNIQUE (_id));

Solution

Rename or quote the check column since check is a keyword in SQL.

For example:

private static final String DATABASE_CREATE =
    "CREATE TABLE if not exists " + SQLITE_TABLE + " (" +
            KEY_ROWID + " integer PRIMARY KEY autoincrement," +
            KEY_CURSUS + "," +
            KEY_ONDERDEEL + "," +
            KEY_GAME + "," +
            KEY_TIJD + "," +
            KEY_WEB + "," +
            + "`" + KEY_CHECK + "`," +
            " UNIQUE (" + KEY_ROWID +"));";

Comments

[Miguel Maciel]

Look here: stackoverflow.com/questions/18718178/…

[laalto]

This isn't the issue - it's all right to have columns with just the name specified. The problem is using a reserved word check as a column name which confuses the SQL parser.

[user2378812]

Thanks laalto (and CRUSADER)!

[anoo_radha]

I made the same mistake by naming a column as 'cast'. I realized the mistake after reading your answer. Thanks

[Al Lelopath]

Same problem for me except my column name was 'group'