/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 vote284 views1 answer
Sql value exists in column
SQL
3 votes293 views4 answers
Order by desc postgres
SQL
0 vote275 views1 answer
Convert sql server guid to varbinary
SQL
15 votes288 views4 answers
How to get all tables in sql
SQL
0 vote301 views1 answer
Show the colums of table sql
SQL
0 vote306 views1 answer
Mariadb datetime change to microseconds
SQL
2 votes293 views1 answer
Mysql Incorrect column specifier for column
SQL
21 votes281 views3 answers
Average sql
SQL
1 vote330 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
7 votes292 views6 answers
Group_concat in mysql
SQL