Removal of several non-cooled records



  • There's a table. products

    Goods from another location are removed to this table. Loading is done by fox xml file and follow-up insert/update

    So the question is, last time, it went off. 10000 and today the manager deleted 40 goods and already unloaded 9960♪ How to remove from the table products these are these. 40 goods?

    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. products and 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 != 'ключ текущего обновления'




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2