MYSQL - UPDATE multiple rows from another table
<p>I have 2 tables. one from yesterday (300k rows) and another one from today with the same count of rows but the data changes in some columns.</p>

<p>Those two tables have around 120 columns. </p>

<p>How can i update only the changes.<br>
I have tried using delete :</p>

<pre><code>   delete from tableA
   where id in (select id from tableB)
</code></pre>

<p>But it too slow.<br>
Also tried</p>

<pre><code>   update tableA inner join tableB
   on tableA.id=TableB.id
</code></pre>

<p>And it didn't worked.</p>

<p><a href="https://i.stack.imgur.com/p0Rok.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/p0Rok.jpg" alt="enter image description here"></a></p>