Thank you Suzon, but I have a range or list of specific barcodes identified to be kept in reference, ex: 1, 253, 588 etc, it is random. In this case, in SQL, should I write.
UPDATE items SET notforloan =1, location = 'REF' WHERE barcode = '1', '253' with thanks Satish On Fri, Apr 1, 2016 at 11:58 AM, Suzon Das <[email protected]> wrote: > 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 <[email protected]> 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 <[email protected]> > > 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 <[email protected]> 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 > >> > *[email protected] <[email protected]>* > >> > > >> > 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 <[email protected]> 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 > >> >> [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 > >> > > >> > >> > >> -- > >> > >> *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 [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
