UPDATE `comp_supplier_creditnote_detail` SET `itemID` = '26', `invoiceDetailID` = '538', `updatedBy` = '16', `itemdescription` = 'Chair with Cover', `quantity` = '1', `unitPrice` = '10.00', `amountExcludedTax` = '10.00', `taxID` = '782', `taxRate` = '6', `taxAmount` = '0.60', `amountIncludedTax` = '10.60' WHERE `ID` =  '76'