/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 vote217 views3 answers
Connection string mysql
SQL
0 vote229 views1 answer
Postgres row expiration
SQL
0 vote217 views1 answer
How to reset table in sql server
SQL
2 votes223 views1 answer
Query to check cpu utilization in oracle database
SQL
1 vote289 views1 answer
Sql and
SQL
5 votes266 views1 answer
Oracle ora-00054 find
SQL
7 votes204 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote231 views1 answer
How to print some string in mysql
SQL
11 votes231 views2 answers
You are using safe update mode
SQL
0 vote215 views1 answer
Add SuperUser MySQL
SQL