Column update of a table with data from another table

Asked

Viewed 22 times

0

how can 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 too long, actually it’s not running, server stops. bank mysql

sql-update

1 answer

0

worked, demoted a little /* Connection with 127.0.0.1 closed on 2018-07-26 01:49:45 / / Affected records: 7,344 Records found: 0 Notices: 0 Duration of 1 consultation: 00:09:11 / / Connecting to 127.0.0.1 via Mysql (TCP/IP), root user, using password: No... */

Browser other questions tagged sql-update

You are not signed in. Login or sign up in order to post.