Removal of several non-cooled records
There's a table.
Goods from another location are removed to this table. Loading is done by fox
xmlfile and follow-up
So the question is, last time, it went off.
10000and today the manager deleted
40goods and already unloaded
9960♪ How to remove from the table
productsthese are these.
The option of choosing 10000 idyshnics into the mass and gradually removing them from another idyshnic is somehow not impressive, is there anything better?
Add another field to the table.
productsand write id off when updated, e.g. the date of renewal or md5 xash of the source file. Upon completion of the update
delete from products where transaction_key != 'ключ текущего обновления'