[Koha] Update a field using SQL

[Paul A]

At 01:55 AM 1/9/2015 +0000, CTS-Programmer 3 (Paul Dokken) wrote:
>I was able to get the query to run in PHPAdmin after changing to the 
>correct table name.  I was not able to get the corrected query to run in 
>MySQL Workbench though.

Try:

UPDATE items SET price='2.00' WHERE barcode LIKE '37000001';

Note table name and case of fields -- 
<http://schema.koha-community.org/tables/items.html> is your friend.  Also 
note the semi-colon at end.

Paul



>Thanks, Paul
>
>
>
>Paul Dokken
>Software Developer
>SIL PNG Communication and Technology Services
>Ukarumpa EHP 444 | Papua New Guinea
>cts-prog3 at sil.org.pg
>+675-537-3544 x4404 {Telecom}
>+675-7081-8666 {Digicel}
>
>
>
>-----Original Message-----
>From: CTS-Programmer 3 (Paul Dokken) [mailto:cts-prog3 at sil.org.pg]
>Sent: Tuesday, 6 January 2015 2:27 PM
>To: koha at lists.katipo.co.nz
>Subject: [Koha] Update a field using SQL
>
>Hi am running Koha 3.18.  I want to run some SQL queries to update some 
>fields.  When I try and run a simple query like UPDATE item SET PRICE = 
>2.00 WHERE BARCODE = '37000001' it just says executing query until I stop 
>it. I am using MySQL Workbench from the Koha host and running under root 
>user.  Anything special I have to do?
>
>Thanks, Paul
>
>
>
>Paul Dokken
>Software Developer
>SIL PNG Communication and Technology Services Ukarumpa EHP 444 | Papua New 
>Guinea cts-prog3 at sil.org.pg
>+675-537-3544 x4404 {Telecom}
>+675-7081-8666 {Digicel}
>
>
>
>
>_______________________________________________
>Koha mailing list  http://koha-community.org
>Koha at lists.katipo.co.nz
>http://lists.katipo.co.nz/mailman/listinfo/koha

---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://NavalMarineArchive.com> and <http://UltraMarine.ca>