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
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.