syntax error in alter table add column
got a syntax error saying near "," while compile in the following code:
db.execSQL("ALTER TABLE " + TABLE_NAME + " ADD " + TOADD1 + " VARCHAR," + TOADD2 + " VARCHAR," + TOADD3 + " VARCHAR");
Where is the syntax error?
Thanks in advance.
ALTER TABLE supports only adding one column at a time as seen in the syntax diagram:
If you need to add three columns, split it to three separate ALTER TABLEs.