3 01:54
An: Benjamin Stadin , General Discussion of
SQLite Database
Betreff: Re: [sqlite] Comparing two tables column by column
The approach I am using to compare tableA_old and tableA_new is;
typedef struct container_t {
// a structure to pass parameters into callbacks
} container;
static int
01:54
> An: Benjamin Stadin , General
> Discussion of SQLite Database
> Betreff: Re: [sqlite] Comparing two tables column by column
>
> The approach I am using to compare tableA_old and tableA_new is;
>
> typedef struct container_t {
> // a structure to pass parameters into callbacks
.@heidelberg-mobil.com>>,
General Discussion of SQLite Database
mailto:sqlite-users@sqlite.org>>
Betreff: Re: [sqlite] Comparing two tables column by column
The approach I am using to compare tableA_old and tableA_new is;
typedef struct container_t {
// a structure to pass parameters in
__
From: "Stadin, Benjamin"
To: Fehmi Noyan ISI ; General Discussion of SQLite
Database
Sent: Tuesday, July 30, 2013 9:00 AM
Subject: Re: [sqlite] Comparing two tables column by column
If you like ruby, I have another idea to get you going (maybe without
needing
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
>To: General Discussion of SQLite Database
>Sent: Monday, July 29, 2
: General Discussion of SQLite Database
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
wrote:
> Wouldn't
>
> SELECT * FROM table1
> EXCEPT
> SELECT * FROM table2
>
> solve
On 29 Jul 2013, at 12:36pm, Fabian Klebert
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
]
Im Auftrag von Stephen Chrzanowski
Gesendet: Montag, 29. Juli 2013 13:01
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] Comparing two tables column by column
To be fair to me, the example had the same column names. If the two tables
have the same column names, then having a b
To be fair to me, the example had the same column names. If the two tables
have the same column names, then having a bit of extra code to tag on the
column name + "_1" might have worked. As my first reply answered,
untested. ;)
On Mon, Jul 29, 2013 at 6:46 AM, Clemens Ladisch wrote:
> Simon S
Simon Slavin wrote:
> On 29 Jul 2013, at 4:03am, Fehmi Noyan ISI wrote:
>> One point I forgot to mention; the number of columns is unknown.
>
> There is no way in SQL to say "Give me the contents of all the columns of a
> row of table in an unambiguous format.".
Well, just "give me" could be don
Yes, it turned out that achieving the goal with C code is much simpler than
using SQL statements (I also take my limited sql knowledge into account)
Now, I'll have two sqlite3_exec() calls, one of which is invoked by first
call's callback function. This led having some natsy C structs around to
On 29 Jul 2013, at 4:03am, Fehmi Noyan ISI wrote:
> One point I forgot to mention; the number of columns is unknown.
There is no way in SQL to say "Give me the contents of all the columns of a row
of table in an unambiguous format.".
It would be possible to write the code you want in SQLite,
: Monday, July 29, 2013 12:31 PM
Subject: Re: [sqlite] Comparing two tables column by column
Untested
select table1.col1 as Key, table1.col2 as T1C2, table1.col3 as T1C3,
table1.col4 as T1C4, table2.col2 as T2C2, table2.col3 as T2C3, table2.col4 as
T2C4 from Table1 join Table2 on Table1.Col1
Untested
select table1.col1 as Key, table1.col2 as T1C2, table1.col3 as T1C3,
table1.col4 as T1C4, table2.col2 as T2C2, table2.col3 as T2C3, table2.col4
as T2C4 from Table1 join Table2 on Table1.Col1=Table2.Col2 order by
table1.col1
On Sun, Jul 28, 2013 at 10:44 PM, Fehmi Noyan ISI wrote:
> Hi
14 matches
Mail list logo
