SQLite: Syntax error in CREATE TABLE statement

Question

I'm trying to execute this statement in onUpgrade method of database helper but I'm getting an error:

 database.execSQL("CREATE TABLE VEHICLE_HOURS(ID INTEGER PRIMARY KEY AUTOINCREMENT, " +
            "MINUTES INTEGER, VEHICLE VARCHAR(255), ORDER INTEGER);");

ERROR

Caused by: android.database.sqlite.SQLiteException: near "ORDER": syntax error (code 1): , while compiling: CREATE TABLE VEHICLE_HOURS(ID INTEGER PRIMARY KEY AUTOINCREMENT, MINUTES INTEGER, VEHICLE VARCHAR(255), ORDER INTEGER);

Thanks.

order is a reserved word in SQL. Even if allowed, you should not sue it for a column name. — Gordon Linoff
– Gordon Linoff, Commented Feb 1, 2016 at 12:03
Possible duplicate of What SQLite column name can be/cannot be? — Tharif
– Tharif, Commented Feb 1, 2016 at 12:09

bereal · Accepted Answer · 2016-02-01 12:08:20Z

3

ORDER is a reserved word in SQL. You could of course suppress that error by taking the name into quotes, like:

database.execSQL("CREATE TABLE VEHICLE_HOURS(ID INTEGER PRIMARY KEY AUTOINCREMENT, " +
        "MINUTES INTEGER, VEHICLE VARCHAR(255), \"ORDER\" INTEGER);");

but better just pick another column name, then nobody (including your future self) will hate you while maintaining this code.

answered Feb 1, 2016 at 12:08

bereal

34.7k8 gold badges65 silver badges111 bronze badges

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

1 Comment

Heshan Sandeepa Over a year ago

Got caught in this, I was trying to do the same & failed. Changed the table name & it worked.

Collectives™ on Stack Overflow

SQLite: Syntax error in CREATE TABLE statement

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related