/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 vote122 views2 answers
Postgres cast as decimal
SQL
0 vote68 views2 answers
Denormalization in sql
SQL
0 vote113 views1 answer
Sql describe
SQL
8 votes115 views3 answers
Alter table auto_increment
SQL
0 vote107 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote73 views1 answer
How to check oracle index table
SQL
0 vote135 views1 answer
Define a variable in mysql from select
SQL
3 votes114 views4 answers
Stop MySQL
SQL
27 votes105 views5 answers
Add column in table
SQL
9 votes114 views4 answers
How to alter table column name in mysql
SQL