I'm making an update to table A which will receive values from Table B
as a.codigo = B.folha
When running the routine below, it is slow and nothing happens for a long time. There are 500,000 lines. It's normal or I have to wait or the script is wrong ... I do not know what to do in the routine
in fact I have to bring information from B to A as per the condition.
UPDATE escrituras t1 INNER JOIN
imovel t2 ON t2.LIVRO = t1.CODIGO
SET
t1.TipoImovelDescr = t2.DESCRICAO;
a.RUA = b.RUA;
a.BAIRRO = b.BAIRRO,
a.MUNICIPIO = b.CIDADE,
a.UF = b.ESTADO