SQLite Forum

how can i identify the data is just inserted into the database or updated the existed item when i use upsert-clause
Use two statements with one by each?  

The purpose of being able to do two by each is to do to by each so you do not have to do the statements one by each.  

If you need to do the process one by each so you can get a count of each then do each separately and not together.