SQLite Forum

how can i identify the data is just inserted into the database or updated the existed item when i use upsert-clause
Login
the sqlite3_changes() always returns 1 when i use upsert-clause like "
insert into table1(col1, col2) values(1, 2) on conflict(col1) do update set col2 = excluded.col2;"

is there any other api can help me to identify those two situations?