On 14 Nov 2019, at 10:27pm, Jake Thaw <[email protected]> wrote: > Why not like this? > > insert into t (a, b, c, d, e, idate) > SELECT a, b, c, 'y', e, '2019-02-12' FROM t WHERE a = 'p001' ORDER BY > idate desc limit 1;
Dammit. I thought I had tried this, and received a syntax error. Now I see that it was because I missed out a comma. Thanks for the correction. Good illustration of why responses should go to the list rather than direct to the OP. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
