https://bugs.kde.org/show_bug.cgi?id=334014
--- Comment #3 from Daniel Vrátil <[email protected]> --- Oh, stupid MySQL :-) This hack should work: DELETE FROM CollectionTable WHERE parentId NOT IN (SELECT * FROM (SELECT id FROM CollectionTable)) AND parentId IS NOT NULL; Sorry, I tested only with PostgreSQL, where DELETE FROM..SELECT FROM on the same table works. -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Kdepim-bugs mailing list [email protected] https://mail.kde.org/mailman/listinfo/kdepim-bugs
