· 8 years ago · Aug 06, 2018, 04:20 AM
1data duplication in sqlite with android app
2String query = "CREATE TABLE IF NOT EXISTS PhoneBook ("+
3"TelNum VARCHAR(100) PRIMARY KEY NOT NULL,"+
4"Address TEXT);";
5
6db.execSQL(query);
7
8db.execSQL("PRAGMA foreign_keys = ON;"); //enforcing FK
9
10REPLACE INTO my_table (pk_id, col1) VALUES (5, '123');