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

https://www.sqlite.org/lang_keywords.html – Phantômaxx Jun 11 '15 at 14:01 — Phantômaxx, Jun 11 '15 at 14:01
@DerGolem Thanks for pointing me – Naga Jun 11 '15 at 14:20 — Naga, Jun 11 '15 at 14:20

score 7 · Accepted Answer · answered Jun 11 '15 at 13:58

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 '15 at 13:58

Giru Bhai

score 4 · Answer 2 · answered Jun 11 '15 at 13:58

4

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

answered Jun 11 '15 at 13:58

Hysteria86

2 Answers2