How are you connecting to MySQL? Through ODBC or through the MySQL administrator, or running commands directly in the command line? James Winter 215.517.2588 From: Roche III, Edward [mailto:edward_roche@solanco.k12.pa.us] Sent: Friday, March 06, 2009 1:32 PM To: Winter, James; koha@lists.katipo.co.nz Subject: RE: [Koha] Mass updating a field I get this error: Output from SQL command UPDATE items i, temp t SET i.barcode = t.barcode WHERE i.itemnumber = t.itemnumber .. No data returned Just about everything I tried so far gives me this error. Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" From: Winter, James [mailto:WinterJ@arcadia.edu] Sent: Friday, March 06, 2009 1:26 PM To: Roche III, Edward; koha@lists.katipo.co.nz Subject: RE: [Koha] Mass updating a field UPDATE items i, temptable t SET i.barcode = t.barcode WHERE i.itemnumber = t.itemnumber James Winter 215.517.2588 From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Roche III, Edward Sent: Friday, March 06, 2009 1:24 PM To: koha@lists.katipo.co.nz Subject: [Koha] Mass updating a field Good Afternoon All I am in need of a SQL statement to update my barcode field in the items table. When we exported our catalog from Follett it removed a space that was in out barcodes so now when we try to scan an item it is not being found because the barcode field in Koha is missing the space. What I have done so far: 1) Export from the items table: itemnumber and barcode 2) Added the space back into the barcode field 3) Created a temp table in the koha db 4) Imported the data into the temp table I now need to move the data from the temp table over to the items table to update the barcode field. Any thoughts? Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?"
