Create table sqlite syntax error

Question

Caused by: android.database.sqlite.SQLiteException: near "case": syntax error (code 1):, while compiling

At

CREATE TABLE case ( case_id TEXT PRIMARY KEY, case_body TEXT, case_title TEXT, case_published INTEGER, case_thumbnil TEXT,case_type TEXT );

Can any one please tell me what is the problem, I am testing this on Android 5.0.2

I have checked

and this

But could not get answer

Giru Bhai · Accepted Answer · 2015-06-11 13:58:44Z

7

Because you cannot use reserved keywords to name table.

For more info see SQLite Keywords

So you may Change

CREATE TABLE case

to

CREATE TABLE caseTable

answered Jun 11, 2015 at 13:58

Giru Bhai

14.4k5 gold badges50 silver badges74 bronze badges

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

Comments

Hysteria86 · Accepted Answer · 2015-06-11 13:58:35Z

4

Is it because CASE is a reserved SQL keyword? Try CREATE TABLE [case]

answered Jun 11, 2015 at 13:58

Hysteria86

3771 silver badge10 bronze badges