On Saturday, February 19, 2011 at 10:17 AM, Black, Michael (IS) wrote:
> sqlite> create virtual table data using fts4(content text);
> sqlite> insert into data values('one two');
> sqlite> insert or replace into data(content) select content||' three four'
> from data where docid=1;
>
> The docid=1 doesn't work the way I want and I can't seem to figure out how to
> put in an "as" clause to make it work. Should end up with just one record
> but, of course, get 2.
>
Shouldn't an UPDATE just work?
UPDATE data
SET content = content || ' three four'
WHERE docid = 1;
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
