Android SQLite error syntax error (code 1)

Question

@Override
public void onCreate(SQLiteDatabase db) {
String CREATE_DATES_TABLE = "CREATE TABLE" + TABLE_NAME + "(" + COLUMN_DATES + "TEXT"+ ")";
    db.execSQL(CREATE_DATES_TABLE);
}

what wrong with syntax ?

You should post the error syntax as well

John Joe
– John Joe

2017-05-17 15:55:36 +00:00
Commented May 17, 2017 at 15:55 — John Joe
– John Joe, Commented May 17, 2017 at 15:55

Stephen · Accepted Answer · 2017-05-17 15:54:17Z

2

You are missing space between your keywords and values

String CREATE_DATES_TABLE = "CREATE TABLE" + TABLE_NAME + "(" + COLUMN_DATES + "TEXT"+ ")";

should be

String CREATE_DATES_TABLE = "CREATE TABLE " + TABLE_NAME + " (" + COLUMN_DATES + " TEXT)";

answered May 17, 2017 at 15:54

Stephen

4,27925 silver badges44 bronze badges

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

Comments

Zoe - Save the data dump · Accepted Answer · 2017-05-17 15:57:00Z

1

YOu are missing a space between the column name and column type, which in your case is TEXT. It should be:

String CREATE_DATES_TABLE = "CREATE TABLE " + TABLE_NAME + " (" + COLUMN_DATES + " TEXT)";

And you may want to use "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + "(..... to ensure you don't create the table if it exists(if that is a function you want).

answered May 17, 2017 at 15:57

Zoe - Save the data dump

28.4k22 gold badges130 silver badges163 bronze badges

Collectives™ on Stack Overflow

Android SQLite error syntax error (code 1)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related