SQLite Forum

BatchUpdate - continue on error
Login

BatchUpdate - continue on error

(1) By RoinujNosde on 2020-08-09 11:52:48 [source]

Hello,

Does SQLite continue Batch updates if one of the statements errored?

(2) By Richard Hipp (drh) on 2020-08-09 12:52:33 in reply to 1 [link] [source]

It does if you use UPDATE OR IGNORE. Otherwise not. See the ON CONFLICT documentation for further information.