[Koha] SQL - Request for change in shelving location

[SATISH]

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 <suzonduislm52 at gmail.com> 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 <lis4satish at 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 <suzonduislm52 at 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 <jcoehoorn at 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
> >> > *jcoehoorn at york.edu <jcoehoorn at 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 <lis4satish at 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 at lists.katipo.co.nz
> >> >> https://lists.katipo.co.nz/mailman/listinfo/koha
> >> >>
> >> > _______________________________________________
> >> > Koha mailing list  http://koha-community.org
> >> > Koha at 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
>



--