UPDATE `comp_supplier_creditnote_detail` SET `itemID` = '26', `updatedBy` = '16', `itemdescription` = 'Chair with Cover', `quantity` = '2', `unitPrice` = '10.00', `amountExcludedTax` = '20.00', `taxID` = '782', `taxRate` = '6', `taxAmount` = '1.20', `amountIncludedTax` = '21.20' WHERE `ID` =  '57'