title: MySQL 1443: what does it mean?
body: <p>I'm trying to do an update, in MySQL 5.0, of the form:</p>
  
  <pre><code>update mytable.myfield t
  set f = 'blah'
  where t.id in (select v.id from myview v where ...);
  </code></pre>
  
  <p>MySQL tells me:</p>
  
  <pre><code>ErrorNr. 1443
  The definition of table 'v' prevents operation UPDATE on table 't'.
  </code></pre>
  
  <p>The MySQL docs list this error, but (as usual) don't say what it means.  Can anyone shed some light on this for me?  I only reference the view in the subquery, and I only reference the table in the main query, and I don't know why these would prevent the update.  The only thing I found with google is a bug in the MySQL bug db related to triggers, but (AFAIK) there are no triggers in my db.</p>