MySQL Forums :: Newbie :: View insertion failing

Advanced Search

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

Subject Written By Posted
View insertion failing Tripta Kaku 02/10/2009 04:50AM
Re: View insertion failing Rick James 02/13/2009 11:46PM
Re: View insertion failing Guelphdad Lake 02/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.