/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 vote285 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
0 vote350 views1 answer
Sql server synonym
SQL
3 votes311 views1 answer
Sql timestamp to date
SQL
7 votes319 views2 answers
What is sql clause
SQL
0 vote289 views1 answer
Sql roll up rows into columns
SQL
3 votes325 views5 answers
Foreign keys
SQL
-1 vote322 views1 answer
Can pandas fetch data from sql
SQL
0 vote309 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
1 vote300 views1 answer
List index mysql cli
SQL
1 vote341 views1 answer
Alter constraint in sql
SQL