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 さん（[email protected]）のメッセージ: > On 11/6/18, 畑宏和 <[email protected]> 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 > [email protected] > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
