/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

0 vote254 views1 answer
Get create sql of hibernqte entity
SQL
1 vote254 views1 answer
Sql where last 12 months
SQL
1 vote261 views1 answer
Oracle turn off constraint
SQL
6 votes266 views2 answers
If not exists insert sql
SQL
0 vote281 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote261 views1 answer
What is top n result in sql
SQL
0 vote257 views1 answer
Sql order by number not ordered
SQL
11 votes281 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote248 views2 answers
Mysql select date from datetime
SQL
0 vote214 views1 answer
Calculate discount from original price sql
SQL