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-pr...@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 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-pr...@sil.org.pg
+675-537-3544 x4404 {Telecom}
+675-7081-8666 {Digicel}
_______________________________________________
Koha mailing list http://koha-community.org
Koha@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>
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
