[Koha] SQL help - Bulk Card Number modification
Ramakant
ramakant at iitk.ac.in
Fri Jan 19 18:10:36 NZDT 2018
Dear Satish,
With the help of sql query you will resolve your problem.
Make your data in excel sheet then use below query for the same and resolve
your query in bulk
e.g. update borrowers set cardnumber = '4GH17ME18' where cardnumber =
'17ME01';
Regards,
============================================================================
===========
Ramakant
Senior Library Information Assistant
P K Kelkar Library
Indian Institute of Technology Kanpur - 208 016
Email - ramakant at iitk.ac.in, ramakant.iitk at gmail.com
Phone: 0512 6797707 (O), +91 8090049089 (Mo.)
More information about the Koha
mailing list