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 *[email protected] <[email protected]>* *Please contact [email protected] <[email protected]> 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 <[email protected]> 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 > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
