How to get rows processed by a query in MYSQL?

Question

MySQL

The point is the following.
There are two tables t1 and t2 .
t2 stores the result of certain processing on several tables including t1. This processing occurs once a day and first selects from t1 those records that have field=0, after that it connects to other tables, forms the result and writes it to t2.
I need that after this processing, those fields from t1 that were processed change the value of field=1, so that next time there will be more of them to process.
Can this be done on the MYSQL side?

Answer 1

You start a transaction.
Processing lines.
By the same condition, update the rows.
You complete the transaction.
This, in fact, will be simpler and more reliable than any cleverly crafted queries.

Answer 2

And if between "Process lines." and "Update rows by the same condition." there will be a change in table t1 (for example, inserting a record). This condition will no longer apply. How to avoid it?