Doug, on Friday, November 15, 2019 11:42 AM, wrote... > > WRT Jose's original context, and just for my enlightment, what happens with > the following: > > insert into t (a, b, c, d, e, idate) > SELECT a, b, c, 'y', e, '2019-02-12' FROM t WHERE a = 'p999'; > > where p999 does not define a record? Is a new record inserted with values of > a,b,c, and e null?
It does not get inserted. sqlite> drop table t; sqlite> create table t (n INTEGER PRIMARY KEY, a, b, c, d, e, idate); sqlite> insert into t (a, b, c, d, e, idate) values ('p001', 1, 2, 'n', 4, '2019-02-11'); sqlite> insert into t (a, b, c, d, e, idate) values ('p002', 2, 2, 'n', 4, '2019-02-11'); sqlite> insert into t (a, b, c, d, e, idate) values ('p003', 3, 2, 'n', 4, '2019-02-11'); sqlite> insert into t (a, b, c, d, e, idate) values ('p004', 4, 2, 'y', 4, '2019-02-11'); sqlite> insert into t (a, b, c, d, e, idate) values ('p005', 5, 2, 'y', 4, '2019-02-11'); sqlite> select * from t; 1|p001|1|2|n|4|2019-02-11 2|p002|2|2|n|4|2019-02-11 3|p003|3|2|n|4|2019-02-11 4|p004|4|2|y|4|2019-02-11 5|p005|5|2|y|4|2019-02-11 sqlite> insert into t (a, b, c, d, e, idate) ...> SELECT a, b, c, 'y', e, '2019-02-12' FROM t WHERE a = 'p999'; sqlite> select * from t; 1|p001|1|2|n|4|2019-02-11 2|p002|2|2|n|4|2019-02-11 3|p003|3|2|n|4|2019-02-11 4|p004|4|2|y|4|2019-02-11 5|p005|5|2|y|4|2019-02-11 sqlite> josé _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users