subject:"\[Koha\] Update a field using SQL"

Re: [Koha] Update a field using SQL

2015-01-09 Thread Paul A

...@sil.org.pg +675-537-3544 x4404 {Telecom} +675-7081-8666 {Digicel} -Original Message- From: CTS-Programmer 3 (Paul Dokken) [mailto:cts-pr...@sil.org.pg] Sent: Tuesday, 6 January 2015 2:27 PM To: koha@lists.katipo.co.nz Subject: [Koha] Update a field using SQL Hi am running Koha 3.18. I

[Koha] Update a field using SQL

2015-01-07 Thread CTS-Programmer 3 (Paul Dokken)

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 = '3701' it just says executing query until I stop it. I am using MySQL Workbench from the Koha host and running under root