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
