/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

1 vote179 views1 answer
Postgres convert exisiting column to text
SQL
19 votes174 views6 answers
What is mySQL
SQL
1 vote175 views1 answer
SQLSTATE[HY000] [2002]
SQL
2 votes201 views2 answers
Create temporary table in mysql
SQL
0 vote187 views1 answer
Oracle procedure teamplate
SQL
0 vote204 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote170 views1 answer
Difference between 2 query results sql server
SQL
0 vote171 views1 answer
Get db connection detail from sql developer profile
SQL
6 votes172 views1 answer
Rank function in oracle with example
SQL
25 votes222 views4 answers
Import mysql dump command line
SQL