[Koha] Update a field using SQL

CTS-Programmer 3 (Paul Dokken) cts-prog3 at sil.org.pg
Tue Jan 6 17:26:43 NZDT 2015


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}





More information about the Koha mailing list