WOW Clemens Ladisch on Saturday, February 9, 2019 11:44 AM wrote, 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;
wow, that's so simple. Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
