/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 vote83 views2 answers
Last working day in week date function in sql
SQL
1 vote117 views2 answers
Sql server add time to date
SQL
0 vote141 views1 answer
Mysql last friday of current month
SQL
0 vote117 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote121 views1 answer
Python mysql query to dataframe
SQL
8 votes108 views2 answers
Phpmyadmin password
SQL
0 vote106 views1 answer
Call function sql oracle
SQL
0 vote122 views1 answer
Proc sql not in working
SQL
0 vote138 views1 answer
Select * where id = 1,2,3
SQL
0 vote155 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL