View insertion failing


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 !

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!