syntax error while compiling SQLite DB (creating a table) whats wrong with my query?

Question

        public void onCreate(SQLiteDatabase db) {
            String query = "CREATE TABLE " + TABLE_INFO + "(" +
            COLUMN_ID + " INTEGER PRIMARY KEY " +
            COLUMN_DATE + " TEXT " +
            COLUMN_DOCNAME + " TEXT " +
            COLUMN_SYMP + " TEXT " +
            COLUMN_DIGNO + " TEXT " +
            COLUMN_MEDS + " TEXT " +
            ");";
     db.execSQL(query);

What is wrong with this? Getting the AndroidRuntime:

FATAL EXCEPTION: main android.database.sqlite.SQLiteException:                                  
                 near "date": syntax error: ,
 while compiling: CREATE TABLE info(_id INTEGER PRIMARY KEY 
                   date TEXT 
                   docName TEXT symp TEXT digno TEXT meds TEXT );

Error.

Please help

comma , missing after every column datatype

ρяσѕρєя K
– ρяσѕρєя K

2016-01-16 06:29:28 +00:00
Commented Jan 16, 2016 at 6:29 — ρяσѕρєя K
– ρяσѕρєя K, Commented Jan 16, 2016 at 6:29

Psypher · Accepted Answer · 2016-01-16 06:30:43Z

1

You have comma missing in the query after each column, change the query string as below:

String query = "CREATE TABLE " + TABLE_INFO + "(" +
        COLUMN_ID + " INTEGER PRIMARY KEY, " +
        COLUMN_DATE + " TEXT, " +
        COLUMN_DOCNAME + " TEXT, " +
        COLUMN_SYMP + " TEXT, " +
        COLUMN_DIGNO + " TEXT, " +
        COLUMN_MEDS + " TEXT " +
        ");";

answered Jan 16, 2016 at 6:30

Psypher

10.8k12 gold badges63 silver badges83 bronze badges

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

Comments

Krishna Satwaji Khandagale · Accepted Answer · 2016-01-16 06:34:02Z

0

You are missing comma . Add it .

answered Jan 16, 2016 at 6:34

Krishna Satwaji Khandagale

2,27018 silver badges25 bronze badges

1 Comment

Rocky Over a year ago

thanks, later on i figured out my stupid mistake, thanks again

Collectives™ on Stack Overflow

syntax error while compiling SQLite DB (creating a table) whats wrong with my query?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related