As someone who does IT and security for a living, the sql isn't hard to write, but this idea seems incredibly, insanely, horribly awful. What are you really trying to accomplish? Maybe I can suggest a safer way to do this. Joel Coehoorn Director of Information Technology 402.363.5603 *jcoehoorn@york.edu <jcoehoorn@york.edu>* *Please contact helpdesk@york.edu <helpdesk@york.edu> for technical assistance.* The mission of York College is to transform lives through Christ-centered education and to equip students for lifelong service to God, family, and society On Mon, Jun 17, 2019 at 9:11 AM Dixson Rodriges <dixson@focuzinfotech.com> wrote:
Hi,
Is are any mysql query for updating the common password for all patrons.
I tried with following mysql query. but didn't worked out. I think it should be in encrypted format.
update borrowers set password='test123' where cardnumber='1001';
Regards, Dixson --
Best Regards,
Dixson Rodrigues
Manager - Support & Service
FocuzInfotech
(A Division of focuz Innovation Pvt Ltd)
Ph: +91 484 2535390 Mob:09249500540
Save Paper - Do you really need to print this e-mail?
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha