Find and delete duplicates from the collection database: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

    16 August 2022

    • curprev 16:4716:47, 16 August 2022Jonas talk contribs 1,031 bytes +1,031 Created page with "See: https://wiki.strawberrymusicplayer.org/wiki/Accessing_the_database on how to access the database. Exit Strawberry first and backup the file "strawberry.db" in case something goes wrong. You can also use Tools / Console in Strawberry, but it won't show errors, so it's safer to use the sqlite3 command directly. == Find duplicate songs == SELECT s.rowid, s.url FROM songs s INNER JOIN (SELECT url, COUNT(*) FROM songs GROUP BY url HAVING count(*) > 1) d ON s.url..."