View Single Post
Old 12-27-2014, 09:55 AM   #5
PeterT
Grand Sorcerer
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
Posts: 13,572
Karma: 79436804
Join Date: Nov 2007
Location: Toronto
Device: Libra H2O, Libra Colour
The gist of the SQL you want to use is:
Code:
  UPDATE Shelf SET _IsDeleted = 'true', 
               LastModified = <timestamp> 
  WHERE _IsSynced = 'true'
You might want to try using a tool like DBeaver or the SQLite Manager for FireFox
PeterT is offline   Reply With Quote