First, identify those duplicated userid's. (Beware it talks about 'userid', not 'uniqueid'):
SELECT userid FROM (SELECT userid,COUNT(userid) AS the_count FROM borrowers GROUP BY userid) a WHERE the_count > 1;
Then I'd go look at each of the (at least) duplicated userid's like this:
SELECT firstname, surname, email, cardnumber FROM borrowers WHERE userid=<pick one>;
I usually just picked the cardnumber as the new userid:
UPDATE borrowers SET userid=cardnumber WHERE userid=<pick one>;
You could go with the email, it really depends on your taste/common practices. This is not ideal, but should do the work. Good luck Note: You will probably find several userid's to be NULL. In that case, the second query should be like:
SELECT firstname, surname, email, cardnumber FROM borrowers WHERE userid IS NULL;
and so the UPDATE query. 2015-12-21 7:35 GMT-03:00 Phillip Ponchot <pponchot@live.com>:
A recent update to Koha 3.19 pointed out that I have some records in the Borrowers Table that lack a UniqueID so that the UniqueID field could not be made "unique".
I need to update the records in this table. Is there an easy way to do this via mysql?
Thanks,
Phillip
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B76C 6E7C 2D80 551A C765 E225 0A27 2EA1 B2F3 C15F