Re: [sqlite] Comparing a field between two databases?

On Mon, 17 Nov 2008 10:39:17 +0100, Gilles Ganault <[EMAIL PROTECTED]> wrote: >.attach db1.sqlite >.attach db2.sqlite Correction: attach "db1.sqlite" as db1 attach "db2.sqlite" as db2 ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Comparing a field between two databases?

On Sun, 16 Nov 2008 18:28:50 +0900, "Alexandre Courbot" <[EMAIL PROTECTED]> wrote: >attach is probably what you want: Thanks. For those interested, here's how to load two database files into the sqlite3.exe CLI, and retrieve rows that have a common "code" value in two tables: C:\> sqlite3.exe

Re: [sqlite] Comparing a field between two databases?

Hi, attach is probably what you want: http://www.sqlite.org/lang_attach.html Alex. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Comparing a field between two databases?

Hello I have two SQLite files, each with the exact same structure. I need to check the value in a field in both tables, and check if it's identical. Is there a way to use sqlite3.exe to open two databases, and perform a SELECT to compare the value of a field in the databases? Thank you.