Remove me
On Wed, Feb 13, 2019, 12:54 PM Jose Isaias Cabrera
> James K. Lowden, on Tuesday, February 12, 2019 11:39 AM, wrote...
> >On Tue, 12 Feb 2019 15:05:29 +
> >Jose Isaias Cabrera wrote:
> >
> >> >SELECT * From t WHERE datestamp = "20190208"
> >>
> >> Ok, Simon, I'll bite; :-)
James K. Lowden, on Tuesday, February 12, 2019 11:39 AM, wrote...
>On Tue, 12 Feb 2019 15:05:29 +
>Jose Isaias Cabrera wrote:
>
>> >SELECT * From t WHERE datestamp = "20190208"
>>
>> Ok, Simon, I'll bite; :-) Imagine this table:
>>
>> t (n INTEGER PRIMARY KEY, a, b, c, d, e, idate)
>
>That's
Man, you guys are so smart... Thanks, Keith.
From: sqlite-users on behalf of
Keith Medcalf
Sent: Wednesday, February 13, 2019 02:31 AM
To: SQLite mailing list
Subject: Re: [sqlite] Checking differences in tables
insert into t (a, b, c, d, e, idate)
values ('p001', 1, 2,
(SELECT d FROM t
nal Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Kees Nuyt
>Sent: Tuesday, 12 February, 2019 17:55
>To: sqlite-users@mailinglists.sqlite.org
>Subject: Re: [sqlite] Checking differences in tables
>
>On Tue, 12 Feb 2019 2
Kees Nuyt, on Tuesday, February 12, 2019 07:55 PM, wrote...
>On Tue, 12 Feb 2019 21:03:47 +, you wrote:
>> David Raymond, on Tuesday, February 12, 2019 03:48 PM, wrote...
>>> Not sure if this will fix your specific issue, but if you're using a query
>>> as a single
>>> value it needs to be in
On Tue, 12 Feb 2019 21:03:47 +, you wrote:
>
>
>
> David Raymond, on Tuesday, February 12, 2019 03:48 PM, wrote...
>> Not sure if this will fix your specific issue, but if you're using a query
>> as a single
>> value it needs to be in parenthesis, so something like
>>
>> insert into t (a, b,
ite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Jose Isaias Cabrera
Sent: Tuesday, February 12, 2019 3:42 PM
To: James K. Lowden; SQLite mailing list
Subject: Re: [sqlite] Checking differences in tables
>James K. Lowden, on Tuesday, February 12, 2019 11:39 AM, wro
-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Jose Isaias Cabrera
Sent: Tuesday, February 12, 2019 3:42 PM
To: James K. Lowden; SQLite mailing list
Subject: Re: [sqlite] Checking differences in tables
>James K. Lowden, on Tuesday, February 12, 2019
>James K. Lowden, on Tuesday, February 12, 2019 11:39 AM, wrote...
>>On Tue, 12 Feb 2019 15:05:29 +
>>Jose Isaias Cabrera wrote:
>>
>>> >SELECT * From t WHERE datestamp = "20190208"
>>>
>>> Ok, Simon, I'll bite; :-) Imagine this table:
>>>
>>> t (n INTEGER PRIMARY KEY, a, b, c, d, e, idate)
James K. Lowden, on Tuesday, February 12, 2019 11:39 AM, wrote...
>On Tue, 12 Feb 2019 15:05:29 +
>Jose Isaias Cabrera wrote:
>
>> >SELECT * From t WHERE datestamp = "20190208"
>>
>> Ok, Simon, I'll bite; :-) Imagine this table:
>>
>> t (n INTEGER PRIMARY KEY, a, b, c, d, e, idate)
>
>That's
On Tue, 12 Feb 2019 15:05:29 +
Jose Isaias Cabrera wrote:
> >SELECT * From t WHERE datestamp = "20190208"
>
> Ok, Simon, I'll bite; :-) Imagine this table:
>
> t (n INTEGER PRIMARY KEY, a, b, c, d, e, idate)
That's better.
> how would I find the differences in the fields based on the
Simon Slavin, on Saturday, February 9, 2019 11:02 AM, wrote...
>On 9 Feb 2019, at 3:49pm, Jose Isaias Cabrera wrote:
>
>> Imagine this scenario:I have this table,
>>
>> t (a PRIMARY KEY, b, c, d, e)
>>
>> that contains yesterday's data. Today, I rename that table
Warren Young, on Saturday, February 9, 2019 06:15 PM, wrote...
>On Feb 9, 2019, at 12:20 PM, Jose Isaias Cabrera wrote:
>>
>> Warren Young, on Saturday, February 9, 2019 01:36 PM, wrote...
>> >
>> >You may be interested in the sqldiff program that comes with SQLite:
>>
>> Yeah, I know about it,
On Feb 9, 2019, at 12:20 PM, Jose Isaias Cabrera wrote:
>
> Warren Young, on Saturday, February 9, 2019 01:36 PM, wrote...
> >
> >You may be interested in the sqldiff program that comes with SQLite:
>
> Yeah, I know about it, but I thought it was for two different DBs
It is, but that doesn’t
Warren Young, on Saturday, February 9, 2019 01:36 PM, wrote...
>On Feb 9, 2019, at 8:49 AM, Jose Isaias Cabrera wrote:
>>
>> Perhaps, Dr. Hipp and the team can write a quick PRAGMA that can do
>> something like this,
>
>You may be interested in the sqldiff program that comes with SQLite:
>
>$
On Feb 9, 2019, at 8:49 AM, Jose Isaias Cabrera wrote:
>
> Perhaps, Dr. Hipp and the team can write a quick PRAGMA that can do something
> like this,
You may be interested in the sqldiff program that comes with SQLite:
$ sqldiff --help
Usage: sqldiff [options] DB1 DB2
Output SQL text that
WOW
Clemens Ladisch on Saturday, February 9, 2019 11:44 AM wrote,
Jose Isaias Cabrera wrote:
>> t_20190208 (a PRIMARY KEY, b, c, d, e).
>>
>> I create a new table,
>>
>> t (a PRIMARY KEY, b, c, d, e)
>>
>> and insert a set of "new data", which contains changes that happened since
>> yesterday
>>
Jose Isaias Cabrera wrote:
> t_20190208 (a PRIMARY KEY, b, c, d, e).
>
> I create a new table,
>
> t (a PRIMARY KEY, b, c, d, e)
>
> and insert a set of "new data", which contains changes that happened since
> yesterday
> after the new set of data was created. Right now, I bring the data out
Simon Slavin on Saturday, February 9, 2019 11:02 AM wrote...
On 9 Feb 2019, at 3:49pm, Jose Isaias Cabrera wrote:
> Imagine this scenario:I have this table,
>
> t (a PRIMARY KEY, b, c, d, e)
>
> that contains yesterday's data. Today, I rename that table to,
>
> t_20190208 (a PRIMARY KEY, b, c,
On 9 Feb 2019, at 3:49pm, Jose Isaias Cabrera wrote:
> Imagine this scenario:I have this table,
>
> t (a PRIMARY KEY, b, c, d, e)
>
> that contains yesterday's data. Today, I rename that table to,
>
> t_20190208 (a PRIMARY KEY, b, c, d, e).
That's not how you use tables. Your software
Hi Gurus.
Imagine this scenario:I have this table,
t (a PRIMARY KEY, b, c, d, e)
that contains yesterday's data. Today, I rename that table to,
t_20190208 (a PRIMARY KEY, b, c, d, e).
I create a new table,
t (a PRIMARY KEY, b, c, d, e)
and insert a set of "new data", which contains changes
21 matches
Mail list logo