Am 30.09.2018 um 14:53 schrieb J Albrecht:
Can’t all of this command line gobley-gook nevertheless be done in DB Browser
for SQLite? In order to “kill the orphans” (ugghh) one must simply hit a couple
of GUI buttons to conveniently delete the necessary rows in both tables, right?
If you use the GUI, you will get no orphaned rows.
The SQL in my previous Mail will not kill the orphanes but avoid getting
orphanes when using the DB-Browser.
To kill the orphanes after deleting in table "styles" with DB-Browser
use SQL:
DELETE FROM style_items
WHERE NOT EXISTS (SELECT id FROM styles s WHERE s.id = styleid);
--
Frank
____________________________________________________________________________
darktable user mailing list
to unsubscribe send a mail to [email protected]
