UPDATE `comp_acc_det` SET `amountdr` = amountdr +0, `amountcr` = amountcr +1980, `total` = amountdr - amountcr, `updatedBy` = '19' WHERE `companyID` =  '93' AND `acctID` =  '28375' AND `year` =  '2014' AND `period` =  '9'