[Koha] SQL - Request for change in shelving location

[Suzon Das]

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