Monday 31 December 2012

Difference of two Alter Commands -SQLite


String statement = "ALTER TABLE MyTable ADD COLUMN" + name + "text";
sqLiteDatabase.execSQL(statement);

creating table MyTable with column COLUMNname


String statement = "ALTER TABLE MyTable ADD COLUMN " + name + "text";
sqLiteDatabase.execSQL(statement);

creating table MyTable with column name

No comments:

Post a Comment