Column update of one table with data from another

0

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

    
asked by anonymous 26.07.2018 / 06:51

1 answer

0

It worked, took some time / * Connection with 127.0.0.1 closed on 2018-07-26 01:49:45 / / Affected records: 7,344 Records found: 0 Warnings: 0 Query duration: 00:09:11 / / Connecting to 127.0.0.1 via MySQL (TCP / IP), root user, using the password: No ... * /

    
26.07.2018 / 07:03