[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