Here is the code to Set what you requested : UPDATE items SET notforloan =1, location = 'REF' WHERE barcode BETWEEN 1 AND 100
**FYI, this can not be run from Koha Intranet Interface's SQL. Use Command line from Terminal (Alt + Ctrl + T) then login to Mysql->koha_library database. Consider before affecting the original. On 4/1/16, SATISH <lis4sat...@gmail.com> wrote: > Hi Suzon, > Thank you for the reply, > Yes, I have root access to MySql and Koha, > Yes, I understood, altering or updating is dangerous, but > it is very much required to save the time, and I will not touch other sql > tables!! > Please provide the solution!! > > with thanks > Satish > > On Thu, Mar 31, 2016 at 11:41 PM, Suzon Das <suzonduisl...@gmail.com> > wrote: > >> Your requested Sql may be helpful but also dangerous. BTW, If you want >> I may help you. Do you have access to Mysql database of Koha_library? >> >> On 3/31/16, Coehoorn, Joel <jcoeho...@york.edu> wrote: >> > The sql part is not all that hard, but I'm not sure that will do the >> whole >> > job. I might be mistaken about this, but something tells me you'd end >> > up >> > creating a disconnect between the koha database and stored marc data. >> > >> > >> > >> > Joel Coehoorn >> > Director of Information Technology >> > 402.363.5603 >> > *jcoeho...@york.edu <jcoeho...@york.edu>* >> > >> > 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 Wed, Mar 30, 2016 at 1:16 AM, SATISH <lis4sat...@gmail.com> wrote: >> > >> >> Hi, >> >> >> >> My Koha (3.16) has been installed from packages method on ubuntu 12.4 >> LTS >> >> Desktop. >> >> >> >> >> >> I have to set huge number of items (various barcode) among many >> >> Records >> >> into Shelving location called = Reference Section. >> >> >> >> I mean, I have pick specified barcode (item) from each record to a >> >> location >> >> called "Reference section". Previously, While entering bibliographic >> >> details, I did not set specific barcode(item) into location =referece >> >> section, and >> >> now doing manually one by one will consume huge time, therefore, I >> >> request, >> >> >> >> >> >> Using SQL >> >> how to set following two specific conditions for the specified barcode >> >> (item) having barcode numbers from "1, 2, 3..to 100" set to: >> >> >> >> 1) 7- Not for Loan to "Not for Loan" (Previously this field is empty) >> >> 2) c-Shelving Location to " Reference section" (Previously this field >> was >> >> set to shelving location called "General Stock" >> >> >> >> Can koha community, please help me to save my time for doing this job >> >> using >> >> "sql" ?? >> >> >> >> thank you in advance, >> >> Satish MV >> >> Librarian >> >> Govt. Engineering College, >> >> Hassan, Karnataka. >> >> INDIA >> >> -- >> >> _______________________________________________ >> >> Koha mailing list http://koha-community.org >> >> Koha@lists.katipo.co.nz >> >> https://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> > _______________________________________________ >> > Koha mailing list http://koha-community.org >> > Koha@lists.katipo.co.nz >> > https://lists.katipo.co.nz/mailman/listinfo/koha >> > >> >> >> -- >> >> *Suzon Das* >> B.A., M.A. (DU) in Information Sc. and Library Management, >> .NET and Android Developer >> >> Project Manager in >> SBAU Library >> > > > > -- > -- *Suzon Das* B.A., M.A. (DU) in Information Sc. and Library Management, .NET and Android Developer Project Manager in SBAU Library _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
