Thread
: Aura HD
How to delete old Collections stored in Kobo account?
View Single Post
12-27-2014, 09:55 AM
#
5
PeterT
Grand Sorcerer
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
View Public Profile
Find More Posts by PeterT
Track Posts by PeterT via RSS