SQLite

 UPDATE COMPANY
     SET SALARY = SALARY * 0.50
     WHERE AGE IN (SELECT AGE FROM COMPANY_BKP
                   WHERE AGE >= 27 );

*CREATE TABLE

database=openOrCreateDatabase(DB_Name,SQLiteDatabase.CREATE_IF_NECESSARY,null);

String createTable = "CREATE TABLE IF NOT EXISTS hocsinh(_ID INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT, Address TEXT, Phone INTEGER)";

database.execSQL(createTable);

*INSERT

//Insert

String insertTable = "INSERT INTO hocsinh(Name, Phone) VALUES ('Duy',123)";

database.execSQL(insertTable);

//insert

ContentValues valueInsert = new ContentValues();

valueInsert.put("Name", "Hạnh");

valueInsert.put("Address", "HN");

valueInsert.put("Phone", 1234567);

database.insertOrThrow(DB_Table, null, valueInsert);

*UPDATE

String updateTable = "UPDATE hocsinh SET Name='Tien',Phone=12345,Address='HD' WHERE _ID=1";

database.execSQL(updateTable);

//Update

ContentValues valueUpdate = new ContentValues();

valueUpdate.put("Name", "Hạnh");

valueUpdate.put("Address", "HN");

valueUpdate.put("Phone", 1234567);

database.update(DB_Table, valueUpdate, "Name=?", new String[]{"Tien"});

** DELETE

Solution 1: sql.delete(hocsinh,_id<? AND _id>?,new String[]{“5”,”1”});

OR: sql.delete(hocsinh,_id<5 AND _id>1,null);

OR : String deleteTable = "DELETE FROM hocsinh WHERE Name='Duy'";

database.execSQL(deleteTable);

Learing Android