UPDATE `comp_acc_det` SET `amountdr` = amountdr +451508, `amountcr` = amountcr +451508, `total` = amountdr - amountcr, `updatedBy` = '16' WHERE `companyID` =  '1' AND `acctID` =  '2' AND `year` =  '2015' AND `period` =  '0'