EXCEPT query gave the different rows in tables, but what I am after is the different values for existing records.
The column names are exactly the same, however the number of rows may differ (with most of the records are the same). ________________________________ From: Simon Slavin <slav...@bigfraud.org> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Monday, July 29, 2013 9:10 PM Subject: Re: [sqlite] Comparing two tables column by column On 29 Jul 2013, at 12:36pm, Fabian Klebert <f.kleb...@klebert-engineering.de> wrote: > Wouldn't > > SELECT * FROM table1 > EXCEPT > SELECT * FROM table2 > > solve this problem? > I think it does for the example provided. Not sure if it would work in > real-world environment. There are two elements: making sure the same rows are present, and making sure the contents of the rows match. I would probably use EXCEPT commands to find out entries in one database which weren't in the other, then use INTERSECT command to check that the fields in the rows which were in both. But that's just at first glance. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users