In SQLite, suppose that we have the following table: CREATE TABLE IF NOT EXISTS external_data ( name TEXT PRIMARY KEY NOT NULL, atime TEXT NOT NULL, content TEXT NOT NULL ); And we have inserted a row: INSERT INTO external_data VALUES (“name”, “october”, “a”); Plus, we have executed an ‘upsert’ statement: INSERT INTO external_data VALUES…
