On Tue, 29 Jul 2014 16:49:04 -0400
"jose isaias cabrera" <cabr...@wrc.xerox.com> 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';
> ...
> ...
> INSERT OR REPLACE INTO A
> SELECT * FROM client.A WHERE id = 19 AND Date !=
> '2014-06-22'; INSERT OR REPLACE INTO A
> SELECT * FROM client.A WHERE id = 20 AND Date !=
> '2014-06-22';
> END;
Wouldn't the following be simpler and faster?
INSERT OR REPLACE INTO A
SELECT * FROM client.A WHERE id between 1 and 20
AND Date != '2014-06-22';
--jkl
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
