Hi Gurus. Imagine this scenario:I have this table,
t (a PRIMARY KEY, b, c, d, e) that contains yesterday's data. Today, I rename that table to, 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? The output could be something like, field | t_20190208 | t b | 2000 | 2100 e | week | daily etc. Perhaps, Dr. Hipp and the team can write a quick PRAGMA that can do something like this, PRAGMA cktablediff t_20190208 t table_name; Then one can just call SELECT * FROM table_name; Me and my dreams... He he he... josé _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
