MySQL Forums
Forum List  »  Newbie

Syntax on Views; MySQL 5.0.1
Posted by: gadam
Date: August 23, 2004 04:37AM

Hi,
i looking for details on the syntax regarding to 'views'. I can't find anything in the online-manual.
I created a view using the syntax:

CREATE VIEW bla AS SELECT bla FROM bla;

Everything works fine. But when i tried to update the view with this statement:

INSERT INTO bla (bla) values ('bla');

i get the error message:

ERROR 1288 (HY000): The target table viewPatientStatus of the INSERT is not updatable

Can anybody please help me on that?

Thanks.
Gernot

Options: ReplyQuote


Subject
Written By
Posted
Syntax on Views; MySQL 5.0.1
August 23, 2004 04:37AM


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.