/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 vote232 views1 answer
How to print mysql query of codeigniter query builder
SQL
11 votes239 views3 answers
Pl sql example
SQL
2 votes231 views1 answer
Mysql clear screen
SQL
0 vote235 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
3 votes248 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote214 views1 answer
Is not null postgresql
SQL
11 votes233 views4 answers
MYSQL LOGIN
SQL
0 vote241 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote227 views1 answer
Reset keys in sql
SQL
3 votes225 views1 answer
How to check schema privileges in oracle
SQL