UPDATE `comp_sales_creditnote_detail` SET `updatedBy` = '16', `itemID` = '26', `itemdescription` = 'Chair with Cover', `quantity` = '2', `unitPrice` = '2123', `amountExcludedTax` = '4', `taxID` = 0, `taxRate` = 0, `taxAmount` = '254.76', `amountIncludedTax` = '4500.76' WHERE `ID` =  '31'