Hello,
I compare an application every few days which has sqlite as it's client
database.
I look at the content and check whether documents have made it into the
application after it has been built. I also check the metadata in the sqlite
client database for changes.
So, I am constantly comparing the last database with the newer database.
Both databases have exactly the same tables, with only the data being changed
in most of the 51 tables.The largest table has about 3,700,000 rows. Most other
tables have much less rows in them.
Could someone suggest an sql query to find the difference in the same table
(ta) for both the last database (db1) and the newer database (db2)?
I can use SQLiteSpy to connect and attach to the databases.
Thanks for any help to point me in the direction.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
