Am 24.09.2010 20:41, schrieb John Reed: > 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. > use EXCEPT
SELECT col01, col02,... FROM table01 EXCEPT SELECT col01, col02,... FROM table02 ; table01 is the newest table while table02 is its predecessor the result is what is not in table01 greetings Oliver _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
