On Tue, 29 Jul 2014 16:49:04 -0400
"jose isaias cabrera" wrote:
> BEGIN;
> INSERT OR REPLACE INTO A
> SELECT * FROM client.A WHERE id = 1 AND Date != '2014-06-22';
> INSERT OR REPLACE INTO A
> SELECT * FROM client.A WHERE id = 2 AND Date != '2014-06-22';
> ...
> ...
>
"Richard Hipp" wrote...
On Tue, Jul 29, 2014 at 4:49 PM, jose isaias cabrera
wrote:
Is there a way to keep a count of the INSERTS/REPLACES that took place
between the BEGIN and END? I was looking into the SQL changes()
function,
http://www.sqlite.org/lang_corefunc.html#changes
but wou
On Tue, Jul 29, 2014 at 4:49 PM, jose isaias cabrera
wrote:
>
> Is there a way to keep a count of the INSERTS/REPLACES that took place
> between the BEGIN and END? I was looking into the SQL changes() function,
>
> http://www.sqlite.org/lang_corefunc.html#changes
>
> but wouldn't it have to be d
Greetings!
I have this update:
BEGIN;
INSERT OR REPLACE INTO A
SELECT * FROM client.A WHERE id = 1 AND Date != '2014-06-22';
INSERT OR REPLACE INTO A
SELECT * FROM client.A WHERE id = 2 AND Date != '2014-06-22';
...
...
INSERT OR REPLACE INTO A
SELECT * FROM c
4 matches
Mail list logo