UPDATE PALLETS SET = COALESCE(,0)+, = CURDATE() WHERE REC_IDX = AND PAL_IDX =