MySQL 1443: what does this mean?

Question

I am trying to do an update in MySQL 5.0 in the form:

update mytable.myfield t
set f = 'blah'
where t.id in (select v.id from myview v where ...);

MySQL tells me:

ErrorNr. 1443
The definition of table 'v' prevents operation UPDATE on table 't'.

MySQL docs list this error, but (as usual) don't say what that means. Can anyone shed some light on this for me? I refer only to the view in the subquery, and I refer only to the table in the main query, and I do not know why this will prevent the update. The only thing I found with google is the error in the MySQL db error related to triggers, but (AFAIK) there are no triggers in my db.

Answer 1

, myview mytable, , , , , , .

myview, , . .

, .

Rob