I need to set a UPDATE
in a table, however, in the value field: '1481126826.2363343', I need that number to become '1481126826.2363344'
The% w_that I'm trying and the following:
UPDATE callcenter.chamada_agente
SET uniqueid = SUM('1481126826.2363343' + 1)
WHERE id_chamada_agente = 32408
AND tipo_chamada = 'MANUAL'
AND datahora_inicio BETWEEN '2016-11-01 00:00:00' AND '2016-12-15 23:59:59';
Can you help me?