/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

1 vote341 views1 answer
Mysql list bigger table
SQL
1 vote327 views1 answer
Select not matching data with join table
SQL
3 votes317 views1 answer
Mysql replace string in table
SQL
0 vote309 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote328 views1 answer
Sql server query database space available
SQL
0 vote325 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote373 views1 answer
Sql server query all database objects
SQL
1 vote325 views1 answer
How to install mysql 8.0 windows service
SQL
27 votes336 views6 answers
Set password mysql
SQL
1 vote334 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL