MySQL Forums
Forum List  »  Newbie

as views really supported
Posted by: Carl Schwarcz
Date: August 16, 2005 09:43PM

With MySQL 5 beta and InnoDB tables, are views really supported? I can see the syntax in the manual but I get syntax errors on even a trivial attempt to define a view as in

create view foo as select * from project

produces You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'view foo as select * from project' at line 1

Options: ReplyQuote


Subject
Written By
Posted
as views really supported
August 16, 2005 09:43PM


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.