/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 vote176 views1 answer
Adding primery key constraint to a column
SQL
0 vote167 views1 answer
C# mysql update statement set value to null
SQL
0 vote176 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
0 vote172 views1 answer
Copy value from one column to another postgres
SQL
15 votes175 views6 answers
Psql
SQL
1 vote254 views1 answer
Sql server read uncommitted
SQL
1 vote198 views1 answer
Oracle select row max date
SQL
1 vote163 views3 answers
How to truncate foreign key constraint table
SQL
-1 vote187 views1 answer
Mysql select count if contains
SQL
-1 vote182 views2 answers
Sql query examples
SQL