Thanks for your reply! My script's select-stmt do not include where. When I add 'where true', syntax error does not occur.
Thanks! 2018年11月7日(水) 19:44、Richard Hipp さん（d...@sqlite.org）のメッセージ: > On 11/6/18, 畑宏和 <h.hata.a...@gmail.com> wrote: > > Hi, I have a question. > > > > We can use upsert after v3.24.0. > > > > Document <https://www.sqlite.org/lang_insert.html> says that > > `INSERT INTO table-name (column-name) select-stmt upsert-clause` > > But when I try this syntax, it returns syntax error. > > I think we can't use upsert-clause with select-stmt. > > Is this thought right? > > Does your select-stmt include a WHERE clause? It should, even if it > is a no-op like "WHERE true". Try adding the WHERE clause and let us > know if that fixes your problem. > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
