-- Backup
SELECT fcf.id, fcf.data
FROM financeiro_contas_fornecedores fcf
WHERE fcf.conta_id = 3 -- AND fcf.id >= 1943
;

-- list to find ids
SELECT *
FROM financeiro_contas_fornecedores fcf
WHERE fcf.conta_id = 3 AND fcf.id >= 1943
ORDER BY fcf.id;


-- @formatter:off
UPDATE financeiro_contas_fornecedores SET `data` = '2020-01-05' WHERE conta_id = 3 AND id >= 1944 AND id <= 1997;
UPDATE financeiro_contas_fornecedores SET `data` = '2020-02-05' WHERE conta_id = 3 AND id >= 2000 AND id <= 2042;
UPDATE financeiro_contas_fornecedores SET `data` = '2020-03-05' WHERE conta_id = 3 AND id >= 2043 AND id <= 2071;
UPDATE financeiro_contas_fornecedores SET `data` = '2020-04-05' WHERE conta_id = 3 AND id >= 2072 AND id <= 2107;
UPDATE financeiro_contas_fornecedores SET `data` = '2020-05-05' WHERE conta_id = 3 AND id >= 2108 AND id <= 2130;
UPDATE financeiro_contas_fornecedores SET `data` = '2020-06-05' WHERE conta_id = 3 AND id >= 2131 AND id <= 2160;
UPDATE financeiro_contas_fornecedores SET `data` = '2020-07-05' WHERE conta_id = 3 AND id >= 2161 AND id <= 2183;
UPDATE financeiro_contas_fornecedores SET `data` = '2020-08-05' WHERE conta_id = 3 AND id >= 2184 AND id <= 2220;
UPDATE financeiro_contas_fornecedores SET `data` = '2020-09-05' WHERE conta_id = 3 AND id >= 2221 AND id <= 2251;
-- @formatter:on
