Show an actual insert statement that causes an error?

On Wed, Nov 7, 2018, 2:22 AM 畑宏和 <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?
>
> Thanks for reading my post.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to