Jose Isaias Cabrera wrote: > t_20190208 (a PRIMARY KEY, b, c, d, e). > > I create a new table, > > t (a PRIMARY KEY, b, c, d, e) > > and insert a set of "new data", which contains changes that happened since > yesterday > after the new set of data was created. Right now, I bring the data out into > two arrays > and check for the data outside SQLite by iterating through the fields and > checking for > differences, one record at a time, but is there an easier or simpler way > using SQLite > commands?
This query returns all rows that are new or changed: SELECT * FROM t EXCEPT SELECT * FROM t_20190208; Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
