/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

10 votes194 views3 answers
Sql check double value
SQL
3 votes189 views1 answer
Sql datetime as date
SQL
18 votes191 views3 answers
Mysql add column with default value
SQL
1 vote191 views1 answer
Oracle apex run 404
SQL
2 votes215 views1 answer
Ifnull postgres
SQL
0 vote195 views4 answers
Mysql count table rows
SQL
1 vote202 views2 answers
Laravel get sql query eloquent with parameters
SQL
1 vote184 views1 answer
Mysql random limit 1
SQL
2 votes192 views1 answer
Mysql clear screen
SQL
1 vote190 views1 answer
Sql into vs insert into
SQL