I have a php-mysql based web application. At one place, I am trying to insert into a view. I get the error
"Insert failed: SQLSTATE[HY000]: General error: 1471 The target table request_files_v of the INSERT is not insertable-into".
The mysql userid that gives the insert statement, the same userid had been used to define the view. Also, in information_schema.VIEWS, I see that the 'IS_UPDATABLE' field for this view is 'YES'.
What could be the possible reason I am not able to insert into this view?
Thanks in advance for any help !