Update with not in in clause in mysql
<p>From my perspective this query should work</p>

<pre><code>UPDATE tab_antiguedad set rol_id = 4 
where ant_id = 29 
      and rol_id not in (
                         select rol_id 
                         from tab_antiguedad 
                         where usu_id = 55
                        )
</code></pre>

<p><code>Where (select rol_id from tab_antiguedad where usu_id = 55)</code> here <code>rol_id</code> has 4 and 3.</p>

<p>But the mistake that throws me is:</p>

<blockquote>
  <p>You can't specify target table 'tab_antiguedad' for update in FROM
  clause</p>
</blockquote>

<p>Please help.</p>