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
