MySQL Forums
Forum List  »  Newbie

View insertion failing
Posted by: Tripta Kaku
Date: February 10, 2009 04:50AM


I am trying to insert into a view named 'request_files_v'. I get the error

"SQLSTATE[HY000]: General error: 1471 The target table request_files_v of the INSERT is not insertable-into".

I am giving the insert command from the same userid that 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 !

Edited 1 time(s). Last edit at 02/10/2009 04:56AM by Tripta Kaku.

Options: ReplyQuote

Written By
View insertion failing
February 10, 2009 04:50AM
February 13, 2009 11:46PM
February 14, 2009 07:30AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.