How do I perform this update?
update estoque,tabcest
set estoque.cest=tabcest.cest
where locate(trim(tabcest.ncm),estoque.ncm)
and estoque.tipoproduto in ('produto','consumo')
and estoque.cest is null;
It's taking a while, it's not actually running, server stops.
bank mysql