[Koha] Deleting duplicate biblios and biblios without items

[Nicole Engard]

You can only do it from the command line.  I would back up your
database and then to delete the bibs without items run these three
commands in MySQL:

INSERT into deletedbiblio (SELECT * FROM biblio where biblionumber NOT
IN (SELECT biblionumber from items));
INSERT into deletedbiblioitems (SELECT * FROM biblioitems where
biblionumber NOT IN (SELECT biblionumber from items));
DELETE FROM biblio where biblionumber NOT IN (SELECT biblionumber from items);

For duplicates, there are reports to help you find duplicates but not
to delete them:
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Duplicate_titles

Nicole

On Tue, Feb 28, 2012 at 9:02 AM,  <makekee at msu.ac.zw> wrote:
> We have a number of duplicate entries in our database and also biblios
> without items. I would like to know how how one can bulk delete duplicate
> records and all the biblios with no items attached. Thanks in advance
>
> Ephraim Makeke
>
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha