/SQL/Android sqlite add column if not exists

Android sqlite add column if not exists

Cursor cursor = database.rawQuery("SELECT * FROM MY_TABLE", null); // grab cursor for all data
int deleteStateColumnIndex = cursor.getColumnIndex("MISSING_COLUMN");  // see if the column is there
if (deleteStateColumnIndex < 0) { 
    // missing_column not there - add it
    database.execSQL("ALTER TABLE MY_TABLE ADD COLUMN MISSING_COLUMN int null;");
}

Similar codes

49 votes305 views6 answers
Install mysql ubuntu
SQL
1 vote180 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
0 vote210 views1 answer
Where date in datetime mysql
SQL
2 votes187 views4 answers
Sql query interview questions
SQL
5 votes202 views1 answer
Oracle nls instance
SQL
2 votes170 views2 answers
Compare date mysql
SQL
0 vote206 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
5 votes172 views2 answers
Sql conn
SQL
0 vote182 views1 answer
How to use query in nosql
SQL
0 vote278 views3 answers
Get count of null in column sql
SQL